Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance - my SP needs some
Message
De
27/09/2002 18:36:31
 
 
À
27/09/2002 17:14:47
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00705044
Message ID:
00705478
Vues:
9
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform