Re: [SQL] Good Optimization

>     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