ITPUB

Dec 14, 2015 · Databases

Why Adding Indexes Slowed My Query and How an Undocumented Hint Restored Speed

Adding the right indexes to a complex 12‑table query dramatically cut I/O but unexpectedly increased execution time, and the article explains how an undocumented SQL Server hint forced parallelism to bring the runtime back down.