Mr or Mrs. 500
March 2, 2010 at 6:38 am
1. what is the use of INDEX's in SQL?
2. Can we create multiple index's on Single table ?
if yes, what is purpose of that?
plz help me !
Steve Jones - SSC Editor
March 2, 2010 at 7:10 am
Sounds like you are looking for help with homework/tests/interviews.
There are many articles and documentation written on this subject. As a short answer, why don't you start reading and then ask specific questions (http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/).
We are more than happy to help you learn, but we aren't here to do your work for you.
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
March 2, 2010 at 7:44 am
You might also want to read through this series (3 parts)
Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2012 at 2:23 pm
Excellent series on indexing! Thank you!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply