good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^4: DBI placeholders and like statementby jfroebe (Parson) |
on Jun 19, 2013 at 17:48 UTC ( [id://1039813]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|