note
jfroebe
<p>Depending on the DBMS, you could give it an index hint: from tableA (index ndx). You are correct though, most optimizers would simply give it a hard coded selectivity rating which almost always guarantees that an index won't be chosen for that particular column.</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-304796">
<p>Jason L. Froebe</p>
<p><a href="http://jfroebe.livejournal.com">Blog</a>, <a href="http://www.froebe.net/blog">Tech Blog</a></p>
</div></div>
1039600
1039650