Seek and You Shall Scan Part II: Ascending Keys

http://ift.tt/1KO82Gu

In another column I cover cases in which the optimizer uses table or index scans versus ones in which it uses index seeks. I explained when the optimizer's choices were efficient by default and when they weren't (and provided solutions for when they weren't). In this column I continue the discussion by covering a problem known as the ascending key problem.

read more

from SQL Server Pro http://ift.tt/1kCjeYg