>>>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?
>>
>>Nope,
>>Fields you include and/or exclude in the query result have no reflection on the execution plan.
>>But these fields which you use in WHERE clause or in JOINs have.
>
>Boris,
>
>That's not exactly true.
>
>Check this blog post
>
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-covering-indexesThanks!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
