Question: Q6 Indexes 20 Points Consider the SQL script given below. It is meant to create three Indexes 11, 12, and 13 on . columns a,

 Q6 Indexes 20 Points Consider the SQL script given below. It

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 Tablet, 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 (il) Tablet contains millions of records. Line # SQL Script 1 2 3 If Exist Drop Index 11, 12, 13 Create Clustering Index 11 on Tablel on Column (a); Create Nonclustering Index 12 on Tablel on Column (b); Create Nonclustering Index 13 on Tablel on Column (c); Review the script and answer the True/False questions below. Q6.1 4 Points The script can be optimized (in terms of execution time) by changing the order of the create index statements True O False Q6.2 4 Points 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). True O False Q6.3 4 Points 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. O True O False Q6.4 4 Points Now, assume that you are modifying the original scripti) change the word Clustering to Nonclustering on line #2, and change the word Nonclustering to Clustering on line #4. That is, I will be nonclustered while 13 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. Tablet will not be sorted. Because, it is already physically sorted. True O False

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!