Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
_WA_sys kind of indexes
Message
 
 
To
03/05/2003 07:01:34
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00784459
Message ID:
00784566
Views:
23
Hi Grigore,

You wouldn't want to create indexes for all columns. You can use SQL Server Index Tuning Wizard to help with your desision. See http://www.sql-server-performance.com/index_tuning_wizard_tips.asp for some tips on how use it.

>Hello and thank you, Sergey
>
>You're the man ;). In the mean time, I found that myself (I haven't slept half of the night reading the BOL :). I understand that creating a lot of indexes slows the updates. In this case, which is better? To create indexes on those columns or to let those statistics alone?
>
>Thank you.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform