Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance - my SP needs some
Message
From
27/09/2002 18:36:31
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00705044
Message ID:
00705478
Views:
8
>>>Can you provide an execution plan?


Anyway, I've looked at the execution plan that the QA provides and it is telling me that most everything costs about 0% except for items:

- Bookmark Lookup: Cost 62%
- Remote Scan 34%
- tablename.PK 3%

The Bookmark tells me to use a Bookmark (RID or Clustring Key) to look up the corresponding row... (WITH PREFETCH)

Any suggestions?

TIA,
MIke
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform