JUMP

This session will teach you how to reduce the logical reads from a scan/range scan using a simple trick using an indexed view. This optimisation will basically allow SQL Server to skip more indexed rows to reduce logical reads. The scenario for this solution is pagination. Using this solution the ever increasing logical reads became extremely extremely extremely small.