All of the following are guidelines for better query design EXCEPT:
A) Understand how indexes are used in query processing
B) Use a lot of self-joins
C) Write simple queries
D) Retrieve on the data that you need

Question

Quizplus · Accepted Answer

Using a lot of self-joins can actually degrade query performance rather than improving it. Instead, it is recommended to use simple queries, retrieve only the necessary data, and understand how indexes are used in query processing to optimize query performance.

All of the Following Are Guidelines for Better Query Design