Microsoft Exam MB6-894 Topic 1 Question 2 Discussion

Section: Develop new elements by using Application Explorer (20-25%)

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.