| Author |
 Topic  |
|
|
tooba
Posting Yak Master
116 Posts |
 Posted - 01/21/2013 : 19:09:13
|
Hi guys,
I have question for you guys,
I have one table ABC (For Example) and Table ABC has few Indexes
First Index on Table ABC
COLUMN_NAME = ABC.COLUMN1
COLUMN_NAME = ABC.COLUMN2
Second Index
Column_Name = ABC.COlumn1
My question is Would it be same. I can understand if i have Query with both column COlumn1 & Column2
then First Index is good. What you think should i delete Second Index or Keep, if i keep second
index its not gonna slow down the performance?
Please guide me.
Thank You |
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
|
tooba
Posting Yak Master
116 Posts |
Posted - 01/21/2013 : 22:45:26
|
Thanks for reply tkizer, One question
First Query:-
Select * from ABC
Where Column1 = '123' and Column2 like '%jaz'
Second Query:-
Select * from ABC
Where Column1 = '123'
Question:- In First and second query what do you think, which Index SQL going to check (First Index or Second Index)?
Thank You. |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
| |
Topic |
|
SQL Index Question
