March 13, 2010 at 9:16 am
Hi friends,
I'm here again looking for some help from you to understand more about Index in SQL.
Days back some one helped me by providing some link for the same but unfortunately I was not satisfied with that.
I would like to know more about Index. When I red some article I got doubts like why Clustered index created to that column why not non clustered index,Why this particular column chosen for index, will the data page get modified when and index is created/dropped if so how it happens,how the index key is pointing to the data which need to be fetched,how the B tree is behaving etc etc... (you might think I doesn't know any thing about Index, in fact that is not wrong!!!! 🙂 )
Can some suggest some books name or article which help me to clear these doubts and understand the proper use of index.I tried Google but there was no luck...
Sorry to write such a big story. Thanks in advance
Regards,
MC
Thanks & Regards,
MC
March 13, 2010 at 9:36 am
http://www.sqlservercentral.com/articles/Indexing/68439/ and the rest of the series.
Also, there's a lot of information, especially on index architecture in the SQL Books Online. Have you read all of that?
If you still have questions afterwards, ask.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply