SQL Server with Mr. Denny:

CREATE INDEX

Nov 27 2008   12:15PM GMT

Back To Basics: Creating Indexes



Posted by: mrdenny
SELECT statement, Back To Basics, CREATE INDEX

After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database.  If you haven’t already done so, its now time to start adding indexes to your database.  The catch with index is that there is such a thing as to much or a good thing.  As you add more and more indexes to your database your INSERT, UPDATE and DELETE commands will being to slow down, as each time you insert a record the insert is committed to the table, as well as to each index on the table. Continued »