October 17, 2007 at 3:44 am
Is there any fast and easy way to indentify index for 260 tables. i am given responsibility to index tables. what should i do
October 17, 2007 at 4:02 am
Have a look at the Database Engine Tuning Advisor http://msdn2.microsoft.com/en-us/library/ms188639.aspx
You can start it from Management Studio Via: Tools-> Database Engine Tuning Advisor
(but do not believe everything it says). It can advise on what indexes you need to create, which is a good starting point. Make sure you agree with what it advises.
Regards,
Andras
October 17, 2007 at 6:42 am
Please tell me that 260 tables were designed with a clustered index as part of the design.
If you left the clustered index off all the tables as you built the system, that's going to be the place to start.
Probably, as all too often happens, the tables were built with the PK defaulting to clustered. That's usually OK, not always, but I'd look, right away.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply