You need to add indexes to a table.
Which two best practices should you follow? Each correct answer presents part of the solution.
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.
C . Maintain indexes by making changes directly in the database.
D . Add as many indexes as possible, since more indexes will lead to better performance.
Answer: AB
Explanation:
You’ll always maintain indexes in a development environment using the table designer versus making changes 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 the index.
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.