Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimisation as per execution plan
Message
 
 
To
12/10/2011 15:13:27
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01526170
Message ID:
01526177
Views:
47
>The execution plan indicates a Key Loookup 66% process on the object which is my primary key. However, the output list shows 8 fields. Is this 66% that CPU intensive because I did not include those 8 fields in the index definition?

BTW, don't know if related, but I found that I'm unable to view the whole thread. It takes too much time.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform