MB6-894 · Question #49
You need to add indexes to a table. Which two best practices should you follow? Each correct answer presents part of the solution.
The correct answer is A. Determine how the table should be organized by specifying a clustered index. B. Specify a primary index to determine the unique key on the table. You'll always maintain indexes in a development environment using the table designer versus makingchanges directly in the database. You'll always specify a clustered index to determine how the table should be organized. You should always specify a primary index to determine the…
Question
You need to add indexes to a table. Which two best practices should you follow? Each correct answer presents part of the solution.
Options
- ADetermine how the table should be organized by specifying a clustered index.
- BSpecify a primary index to determine the unique key on the table.
- CMaintain indexes by making changes directly in the database.
- DAdd as many indexes as possible, since more indexes will lead to better performance.
How the community answered
(25 responses)- A76% (19)
- C16% (4)
- D8% (2)
Explanation
You'll always maintain indexes in a development environment using the table designer versus makingchanges directly in the database. You'll always specify a clustered index to determine how the table should be organized. You should always specify a primary index to determine the unique key on the table. You should only add the index if the speed improvements gained are greater than the cost to update theindex. To maintain efficiency of the index, you should limit the number of columns that you use in the index. It's important to not create duplicate indexes.
Topics
Community Discussion
No community discussion yet for this question.