Indexing Strategies for Windowed Queries

Design composite indexes that specifically serve ordered analytical functions.