ITPro Today logo
SQL ServerIncrease fan-out to reduce index depthIncrease fan-out to reduce index depth
Generally speaking, to find a particular record at the leaf level of the index, the Storage Engine starts at the root of the index and navigates down through each level to find the correct leaf-level page that contains the record being retrieved. This is called traversing the index.
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.