GilaMonster (2/20/2009)
xgcmcbain (2/19/2009)
1) When creating a primary key on a column, is it still necessary to create an index on that column? or would that index serve good another purpose?No. Primary keys are enforced by an index
Thats exactly why i asked this question, i always assumed it had to be doing such. But its order (DESC, ASC) doesnt seem to be an option though?
4) at what point do u have to rebuild indexes?
Rule of thumb is 30% fragmentation. In some cases that may be high, in some cases low.
does sql server do this manually? how do u check this?
5) are there any advantages or disadvantages to creating indexes as constraints instead make a difference or have pros and cons?
If your index is not unique, it can't be a constraint. Constraints can't have include columns, indexes can.
That really that wasnt my question but i would have assumed so. But did not know you can include columns was more concerted of pros and cons of each in proformance