In my Insider newsletter a couple of weeks ago, I discussed how index fragmentation is often considered when designing indexes, but index depth often isnt. In the newsletter I said Id do a more comprehensive blog post with some data, so this is it. Fanout and Index Depth The index depth is determined by the fanout of [&]

The post On index key size, index depth, and performance appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/adCfc_gEUD0/