Which of the following is true about indexes and index design?
A)indexes should be created on columns used by WHERE and BY clauses
B)a composite index is an index on a single column
C)an index is created for every foreign key by default
D)indexes usually speed up write operations

Question

Quizplus · Accepted Answer

Indexes should be created on columns used by WHERE and BY clauses to speed up the search for specific data. Creating indexes on every column can slow down write operations, as every insertion, update, and deletion needs to reorganize the indexes. A composite index is an index on multiple columns, and an index is not created for every foreign key by default.

Which of the Following Is True About Indexes and Index