Eric writes:
> I have no problem using STRAIGHT_JOIN, etc. My problem is really just
> figuring out the optimal join order. Is doing a "SELECT COUNT" on
> each of the tables I'm going to join the way to do it? Isn't there
> potential for the count to take as long as the full query processing
> would take (especially since the attribute I'm doing a range on is not
> indexed)?
>
> eric.
>
> --
> _____ _
> | ____|(_) http://ir.iit.edu/~ej
> | _| | | Page me via ICQ at
> | |___ | | http://wwp.mirabilis.com/19022931
> |______/ | or by mailing [EMAIL PROTECTED]
> |__/
>
Well , first of all this is recommandation only until we further
improve the optimiser.
In most applications relative sizes of tables do not change
drastically. It is extremely rare that a tabla A that has 1000 times
less rows then table B would in short time have 1000 times more rows
then table B.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
