Ænðr E. Feldstraw<p>Yo, <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> tuners and optimizers, I have a question: under what circumstances would a <a href="https://mastodon.social/tags/queryplan" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>queryplan</span></a> prefer a scan of a clustered index rather than a seek of a non-clustered index with the same predicate and output fields? <br> <br>I've been pouring over query plans lately, trying to reduce pressure of processes in an environment that sees thousands of processes running, with hundreds at the same time, contending for data access, CPU time, and file locks.</p>