December 14, 2012 at 2:02 am
what are the reason for missing index in sql server
December 14, 2012 at 2:03 am
Because it is not there?
(probably because the query optimizer thinks certain queries can benefit from the index)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 14, 2012 at 2:06 am
SQL server doesnt automatically create indexes, except in certain cicumstances such as when you define Primary Key, Foreign Key and Unique Key's.
All others have to be manually generated by developers.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
December 14, 2012 at 3:09 am
Jason-299789 (12/14/2012)
SQL server doesnt automatically create indexes, except in certain cicumstances such as when you define Primary Key, Foreign Key and Unique Key's.
Primary key and unique constraint only. Creating a foreign key does not create any indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply