Non Clustered Index using Like in MS SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I Create a table and apply Non Clustered index on [Name] field

if i use like in Query on non clustered index [Name]

how it works?

is Like Query used non clustered Index?

Posted 14-Nov-11 23:07pm

saad.raza

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shabana Parveen · Answer 1 · 2011-11-14T23:10:00

Solution 1

i am not sure but it should work....

Posted 14-Nov-11 23:10pm

Shabana Parveen

RaisKazi · Answer 2 · 2011-11-14T23:17:00

Solution 2

Have a look at below Article.

http://www.sql-server-performance.com/2007/optimizing-indexes-general/

Posted 14-Nov-11 23:17pm

RaisKazi

Mehdi Gholam · Answer 3 · 2011-11-14T23:18:00

Solution 3

Read the following on indexes :

http://sqlserverplanet.com/indexes/sql-server-indexes-tutorial/[^]

http://www.sql-server-performance.com/2004/index-data-structures/[^]

Posted 14-Nov-11 23:18pm

Mehdi Gholam

Non Clustered Index using Like in MS SQL

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Non Clustered Index using Like in MS SQL

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us