SQL Server, Is a Seek Always Only a Seek? Singleton Lookup and Range Scan
Hi Guys, Welcome back for another important post here on my blog! Today we are going to deepen the functioning of a seek and see in more detail how it works . I hope many of you are reading this post. My goal is in fact to explain in the clearest and most interesting way how SQL Server works. If something is not clear to you, just ask, it will help me to improve. Last news before start, in case you are genuinely and truly interested in one of the products that appear in advertising ... click the adv from my blog to support my site! Crew, let's go !!! Recap about index and the way them works Well, first of all we must do a recap about indexes and about the way them works . I blogged many times about index for example, i suggest to read here: SQL Server, Difference between a seek and a scan operation and the Latch coupling An index, clustered or not, has the following structure: Every search start from the Root Page, then continue to the Intermediate pages and finall...