The clustering files physical database design technique ____.
A) is designed to improve the performance of a join operation
B) is likely to hurt the performance of a join operation
C) is designed to improve the performance of data retrievals from a single table
D) is designed to improve the security of the database environment
E) None of the above.

Question

Quizplus · Accepted Answer

Clustering files in a database are designed to improve the performance of join operations by storing related records from different tables close to each other on the disk, reducing the time needed to access and join them.

The Clustering Files Physical Database Design Technique ____