March 12, 2009 at 1:42 am
Ive a question about the dashboard report of the sql 2005 server.
On the Database i can see an missing index report.
Create Index missing_index_64 Clearance.dbo.tblCons([ImageAvailable]),([FlagIX])
next entrie
Create Index missing_index_64 Clearance.dbo.tblCons([FUserID]),([ImageAvailable])
next entrie
Create Index missing_index_64 Clearance.dbo.tblCons([ImageAvailable]),([InsertDate])
How can i set now the indexes, should i insert for each index request an separated index with multiple columns ?
can someone emplain me how i should setup this missing indexes..
March 12, 2009 at 2:10 am
Those are 3 distinct indexes, they can't be merged into one. (Difference leading columns)
Just check in a dev environment that they are actually useful before you go creating them on prod. Also check to make sure you don't already have an index that can be expanded to fit.
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
March 13, 2009 at 1:18 am
sorry but i have still a question.
if i set indexes on the sql table
should i add per index only 1 column
or is there to set an index with multpli columns?
whats the difference of this options ?
March 13, 2009 at 3:41 am
Tody (3/13/2009)
if i set indexes on the sql tableshould i add per index only 1 column
or is there to set an index with multpli columns?
Not sure I understand you.
Indexes should be created to be useful for the queries. If queries only ever filter on 1 column, then make the index 1 column. If queries filter by multiple columns, create indexes on multiple columns.
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