Index optimization is always interesting subject to me. Every time I receive request to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below.… Continue Reading...
Source: SQL SERVER – Index Optimization CheckList | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment