The use of UPPER() in an index - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

The use of UPPER() in an index

Message

De

04/03/2008 02:07:18

Kevin Goff
Pennsylvanie, États-Unis

À

04/03/2008 01:37:03

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

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: The use of UPPER() in an index

Divers

Thread ID:

01298350

Message ID:

01298356

Vues:

27

By default, SQL Server’s use of indexes is case-insensitive

You may also want to take a look at collating sequences.
http://www.sqlteam.com/article/using-indexed-computed-columns-to-improve-performance

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Click here to load this message in the networking platform