1)The script can be optimized (in terms of execution time) by changing the order of the create index statements.

2) Statements are already in the best order to provide the fastest execution of the script. It also makes sense (in terms of index creation order).

3) The second statement must be executed last to achive faster execution of the script. The order of the statements should be either 1,3,4,2 or 1,4,3,2.

4) )Now, assume that you are modifying the original script; i) change the word Clustering to Nonclustering on line #2, and ii) change the word Nonclustering to Clustering on line #4. That is, I1 will be nonclustered while I3 is clustered.

Then, execute the entire script again and imagine what would happen when/after the statement on line #4 is executed. Answer the True/False questions below, accordingly.

Table1 will not be sorted. Because, it is already physically sorted.

5) I1 will be rebuilt.

6) I2 will not be rebuilt.

Q6 Indexes 20 Points Consider the SQL script given below. It is meant to create three indexes 11, 12, and 13 on columns a, b, and c of Table1, respectively. 11 is a clustered index while 12 and 13 are nonclustered. For the sake of completeness, line #1 drops all indexes, if they already exist before the execution of the script. Assume that (i) all of the statements in the script are correct and executed without any problems, and (ii) Table1 contains millions of records. Line # SQL Script 1 NM If Exist Drop Index 11, 12, 13 Create Clustering Index 11 on Tablel on Column (a); Create Nonclustering Index 12 on Table1 on Column (b); Create Nonclustering Index 13 on Tablel on Column (c); Review the script and answer the True/False questions below