Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index Usage Expand / Collapse
Author
Message
Posted Friday, April 26, 2013 5:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 26, 2013 5:33 AM
Points: 2, Visits: 7
Hello,

I have a table with 2 columns which I have a non clustered index on it in the form of column a asc , column b asc .

I ran the below 2 quires against this table and found that only query 1 utilizes index seek while the 2 query is using index scan.

This have forced me to create a second index in the form of column b asc , column a asc to get index seek for both queries

query 1: select column a from table x where column b = x

query 2: select column b from table x where column a = x

So my question here could I use 1 index to cater for both queries?

Regards,
Post #1446911
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse