Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tooba
Posting Yak Master
224 Posts |
Posted - 2013-01-21 : 19:09:13
|
Hi guys, I have question for you guys,I have one table ABC (For Example) and Table ABC has few IndexesFirst Index on Table ABCCOLUMN_NAME = ABC.COLUMN1COLUMN_NAME = ABC.COLUMN2Second IndexColumn_Name = ABC.COlumn1My question is Would it be same. I can understand if i have Query with both column COlumn1 & Column2then First Index is good. What you think should i delete Second Index or Keep, if i keep secondindex its not gonna slow down the performance?Please guide me. Thank You |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
tooba
Posting Yak Master
224 Posts |
Posted - 2013-01-21 : 22:45:26
|
Thanks for reply tkizer, One questionFirst Query:-Select * from ABCWhere Column1 = '123' and Column2 like '%jaz'Second Query:-Select * from ABCWhere 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
38200 Posts |
|
|
|
|