Back to Questions

Database Management MongoDB Objective

Feb 21, 2013

A rule of thumb for choosing indexes for a relational database includes in ?

Choose the correct answer:

A) Indexes are more useful on smaller tables.

B) Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.

C) Do not specify a unique index for the primary key of each table.

D) Be careful indexing attributes that have null values.

Detailed Explanation

Option D is the right answer.

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts

Feedback