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.
Query OptimizationSQL Serverindex
0 likes · 4 min read