I want to know if there is a "Best Pracice" to what I am doing.
I have a table with several fields and I know that 2 of the fields should ideally be sorted for best performance, so I added a cluster index that uses both of those fields.
What I'd like to know is, do I need to add additional individual indexes on both or either one of those fields? Will they help? Will they potentially SLOW things down?
Thanks in advance!!!
I have a table with several fields and I know that 2 of the fields should ideally be sorted for best performance, so I added a cluster index that uses both of those fields.
What I'd like to know is, do I need to add additional individual indexes on both or either one of those fields? Will they help? Will they potentially SLOW things down?
Thanks in advance!!!