What is a good real world maximum(so i am not looking for this answer:http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/) for the number of indexes on a table (table has around 50 columns and at the moment 3 indexes)
. I would like to add 3 more indexes on fields that are not used for joining but are searched upon lots of the time. Is this a good idea?
View Complete Post