Execution plan no join predicate

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Execution plan no join predicate

Message

20/06/2013 21:47:24

Sergey Berezniker
New York, États-Unis

20/06/2013 21:29:04

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: Execution plan no join predicate

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01576802

Message ID:

01576803

Vues:

>On a specific execution plan, SSMS shows a warning sign on "Nested loops (Inner join)" with the text "No join predicate". I have an output list of four items and that's it. The cost is 0%. What does this mean?

Cross join?

--sb--

Répondre

Fil

Voir

Click here to load this message in the networking platform