November 8, 2013 at 10:52 am
Hiii guys,
I have a lot of confusion regarding the indexes in SQL SERVER,
my doubt is that when to apply various indexes,on what columns can be indexes are given and why
also kindly help me to know what indexes are applied based on various scenarios like where,group by etc.....
Regards
Surya
November 8, 2013 at 11:02 am
surya321 (11/8/2013)
Hiii guys,I have a lot of confusion regarding the indexes in SQL SERVER,
my doubt is that when to apply various indexes,on what columns can be indexes are given and why
also kindly help me to know what indexes are applied based on various scenarios like where,group by etc.....
Regards
Surya
Hello and welcome to the forums. Indexing is a big topic. I'd suggest that you start with the stairway on the topic at http://www.sqlservercentral.com/stairway/72399/. That will give you a good foundation and then build on it with each successive article.
November 8, 2013 at 11:24 am
Start with these:
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2013 at 11:39 am
both Ed and Gail have given good resources.
the other thing I'd suggest is that you create a test copy of your db, run some queries, add indexes, and re-run them. Examine the resource usage and time it takes for things to run. See the effects of indexes.
Learn by doing, as well as reading.
November 8, 2013 at 9:55 pm
yeah ok thank you and how to check the resources usage
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply