Looking for best index - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Looking for best index

Message

04/03/2016 15:11:30

04/03/2016 13:22:58

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Versions des environnements

SQL Server:

SQL Server 2014

OS:

Windows 8.1

Network:

Windows 2008 Server

Divers

Thread ID:

01632184

Message ID:

01632557

Vues:

>I do not trust a lot of numbers that shows the sql plan.
>How many rows back?
>
>try
>

>SELECT Client.PrimaryKey
> FROM Client (NOLOCK)
> WHERE Contains (Client.VehicleModel, @VehicleModel)
>

That would be 190 rows.