Re: DW query tuning

From: James Williams <willjamu_at_mindspring.com>
Date: Wed, 10 Apr 2002 01:44:54 GMT
Message-ID: <3cb39866.1654348@nntp.mindspring.com>

On Fri, 05 Apr 2002 15:36:50 GMT, "Darren Mallette" <darren.removethis_at_mallette.remove.com> wrote:

Thanks

I had forgotten about them. The index_combine works. The CBO knows bitmaps are more expensive in 8i and will ignore them when nessacary.

Most of the queries now pick up the bitmaps without the hints since the queries are generated by Business objects.

Also increasing the two bitmap storage parms in the init.ora helped.

Cool! Received on Tue Apr 09 2002 - 20:44:54 CDT