March 2, 2010 at 6:38 am
Hai,
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 !
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.
March 2, 2010 at 7:44 am
You might also want to read through this series (3 parts)
http://www.sqlservercentral.com/articles/Indexing/68439/
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
October 29, 2012 at 2:23 pm
Excellent series on indexing! Thank you!
KU
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply