The clustering files technique can result in slower performance when the records of only one of the files involved must be retrieved.

Question

Quizplus · Accepted Answer

When using the clustering files technique, if the records of only one file need to be retrieved, it still requires navigating through the clustered indexes of both files, which can result in slower performance compared to using a non-clustered index.

The Clustering Files Technique Can Result in Slower Performance When