The following options are immediately applied to the index by using the SET clause in the ALTER INDEX statement: ALLOW_PAGE_LOCKS, ALLOW_ROW_LOCKS, OPTIMIZE_FOR_SEQUENTIAL_KEY, IGNORE_DUP_KEY, and ...

However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a webinar with Gary Jerep ... The practical factors that make tuning complex include a set of physical, ...