DATABASES SQL SERVER PERFORMANCE TUNING: Backward Scanning of an Index. One of the key areas to investigate during performance optimization is the indexing strategy. Not building the right index based on the read pattern may be disastrous specially when databases