Is there any algorithm using by sql server to fetch data using indexes ?

Question

Post reply

Is there any algorithm using by sql server to fetch data using indexes ?

ravi@sql

SSCrazy

Points: 2121
More actions
November 21, 2011 at 9:00 pm

#248150

Hi all,
Is there any algorithm using by sql server to fetch or search data using indexes ?
how exatcly strats search ... using indexes ?
Please explain me each and every steps it tooks to search s data ?
Regards,
Ravi

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ghanshyam.kundu Hall of Fame Points: 3337 More actions · Answer 1

follow these links to get a clear idea of working of indexes

http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

http://www.sqlteam.com/article/sql-server-indexes-the-basics

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Or take a look at ssc stairway series on indexes. http://www.sqlservercentral.com/stairway/72399/[/url]

This is a super set of articles that takes from the basics to pretty in depth stuff. Make sure to read the comments for each article as the discussions are a great extension of the material in many of the articles.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Good visual explaination here too

http://technet.microsoft.com/en-us/sqlserver/gg429790.aspx

Whole list of vids by category

http://sqlskills.com/T_MCMVideos.asp

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass