Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using an index with multiple fields
Message
From
03/05/2011 09:34:44
 
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01509136
Message ID:
01509189
Views:
35
>Check http://sqlserverperformance.wordpress.com/2011/02/04/five-dmv-queries-that-will-make-you-a-superhero-in-2011/

Thanks, so is it that the execution plan information that we see when we move the mouse over an object does not content related information as to which fields we would need to include in order to be optimized?

I see that the second script at http://sqlserverperformance.wordpress.com/2011/01/06/sql-server-index-tuning-for-mere-mortals gives me five records and I can see there is an Included_Columns field. Are those the fields that are suggested to be included in the index I was refering to?

I see also that the fourth script gives me suggestions on new indexes to add. Basically, it is making reference to the same index but with a different set of included fields.

So, basically, are those scripts better to identify which index need to be adjusted in regards to the included fields as well as which one I need to create instead of analyzing the execution plan?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform