[thelist] SQL Madness! Many-to-many selection

[Joshua Olson]

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