1.

Under what conditions should indexes be used?

Answer»

Indexes can be created to enforce uniqueness, to facilitate sorting, and to enable fast retrieval by column values. A good candidate for an index is a column that is frequently used with equal conditions in WHERE clauses.



Discussion

No Comment Found

Related InterviewSolutions