i´m monitoring a process with SQL Profiler and i see this:
CPU - 0
Read - 2
Writes - 0Duration - 892
SELECT TOP 1 * FROM <database_companyname>$Value Entry" WITH (READUNCOMMITTED) WHERE (("Item Ledger Entry No_"[email protected])) ORDER BY "Item Ledger Entry No_","Document No_","Document Line No_","Entry No_
The Index Seek shows me Cost of 49%
The Key Lookup shows me Cost of 52%
I read that i can optimize Key Lookup by creating an index with Included Columns but with a wildcard (*) how can acomplish that?
On the styrk´s book i see that every FINDSET, FINFIRST, ... generates a wilcard, on SQL Query.
Can you help me?