Covering indexes are a crucial performance technique for RDBMS optimization, and one of the most effective tools in the tuning toolbox. When large joined queries suffer from poor performance, here are some tips to tackle the situation. Covering Index basics Covering indexes are indexes which “cover” all columns needed from a specific table, removing the … Continue reading Covering Indexes for Query Optimization