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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

The use of UPPER() in an index

Message

From

04/03/2008 02:07:18

Kevin Goff
Pennsylvania, United States

To

04/03/2008 01:37:03

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

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Re: The use of UPPER() in an index

Miscellaneous

Thread ID:

01298350

Message ID:

01298356

Views:

25

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