1.

Point out the wrong statement.(a) Heap inserts are typically slower than using a clustered index(b) Use partitions and partition SWITCH command; i.e., load a work table that contains a single partition and SWITCH it into the main table after you build the indexes and put the constraints on(c) Use the NOLOCK or TABLOCK hints to remove locking overhead(d) Use a commit size of

Answer»

Right answer is (a) Heap inserts are typically slower than using a clustered index

For EXPLANATION I would say: For using Heap inserts, you may WANT to drop INDEXES and rebuild if you are changing a LARGE part of the DESTINATION table; you will want to test your inserts both by keeping indexes in place and by dropping all indexes and rebuilding to validate.


Discussion

No Comment Found

Related InterviewSolutions