If you’ve ever wondered what happens to your queries if you’re not conscientious about creating indexes, then Fabiano Amorim has yet another nugget of Execution Plan wisdom for you. The Query Optimizer’s solution is to use the Nonclustered Index Spool, and we’re about to learn why.