> Why not let the user select how much time he wants the DB to spend on
> optimization? maybe an explicit "FAST SELECT ..." will skip the costly steps
> for subsecond queries, or "OPTIMIZE SELECT" for the long(hour) queries that
> really need a lot of help :)... Or even a SET OPTION= for turning it on/off?
In most cases, the optimizer knows much better how long to optimize, and
the time it spends is usually very small. Most time is spent in
executor. Pre-6.5 optimizer had problems, so this was not true then.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026