[thelist] SQL Madness! Many-to-many selection
Joshua Olson
joshua at alphashop.net
Fri Aug 17 16:56:48 CDT 2001
Rudy,
: sorry, joshua, but the three-way join with the subselect is the simplest
:
: and simplest almost always translates into fastest
:
: trust your dba, that he or she added the right indexes to your tables
:
: and above all, trust your database engine's optimizer
:
:
: rudy
er, uh, I am the dba in this case... :) Let's hope I got the indexes
right!
Hey Rudy, would the FK fields individually be a better index than a single
joint index with the two, or would a combination of all three indexes work
the best?
-joshua
More information about the thelist
mailing list