Re: Cost-Based or Rule-Based - What's Your Experience

In article <53245.machl001_at_maroon.tc.umn.edu> <machl001_at_maroon.tc.umn.edu> writes:
>
>We are running version 7.1.6 of Orace server on the HP(UX).
>
>A while back I read here that there were a lot of bugs on the
>new cost-based optimization when it was first released. Have
>those bugs been cleaned up with patches and upgrades?
>

 [snip]
>
>What has the experience been out there with more recent releases of
>Server software and using cost-based optimization. Are we going
>down the wrong path?
>

Just be paranoid, and watch it, check its execution plan. It's a great concept, too bad they screwed it up for so long and gave it a bad rep. Remember, all optimizers can be fooled.

>Thanks in advance for your reply.

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O