Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-01-21 : 05:04:43
|
| hi i am working in Sql 2000 around 5 million rows and i need to write several querys with diffrent condition and joins... so i felt index tunning wizard on sql 200 helpful but if i run the query again and again the result of columns to be index will be diff and after few go get a message no index requied.... what is itany idea can i follow the wizard or i need to give the column to index which is the better one manual or wizard.... with regardskhalik |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-21 : 07:38:58
|
| Khalik , its always better to create your own indexes then relying on the wizard. herez a tip you can create indexes for the columns which are in your where clause(but dont create too many of them that will hamper DML's). i would suggest you to search for "Using Clustered Index" and "Using Non-Clustered Indexes" in BOL. you can draw from there series of suggestion on creating each of them.About the wizard changing the recommendations. IMHO( i repeat its my opinion)the first time you execute your query the system has its cached plan the second time it uses the cached plan and tries better routes there by giving another recommedations when you keep executing it the process repeats at one time Sql server comes up with a plan where it doesnt requires any indexes .HTH--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-01-21 : 21:53:09
|
| thanks Nazim.. sure i will referebye |
|
|
|
|
|
|
Index Tunning