I don't want too many though because I know that affects the performance of record inserts. I'm also not sure about using multiple keys in one index.
Is there a good site out there with tips on what indexes to create or avoid, or have I pretty much covered it?Try this article:
http://www.sql-server-performance.com/optimizing_indexes.aspsql
No comments:
Post a Comment