I have been playing around with indexes. I used to think that all id identity fields were automatically indexes but I see they are not and adding the index can really speed up queries.
now my question is - up to how many indexes can you have on a table?
anything else really important to know about indexes?
you can have 1 clustered index and 999 non clustered indexes (why you'd want this many is beyond me, but they are there for you), but you do also have the include option in SQL 2005 and above.
Especially note that a foreign key does *not* add a relevant index. many people assume that it does.
Charlie =============================================================== Msg 3903, Level 16, State 1, Line 1736 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
indexes questions
Posted - 09/20/2010 : 06:03:37
