Re: SQL performance tuning

On Thu, 14 Jun 2001 03:55:56 GMT, Alex Filonov <afilonov_at_pro-ns.net> wrote:

Took about 20 seconds off query.

>Good ideas. In addition:
>
>If you still have plan with hash joins, increase hash_area_size to at least 8M:
>
>alter session set hash_area_size = 8000000; (16M is even better).
>Hash join performance depends too much on hash area size.
>
>
>
>
Received on Thu Jun 14 2001 - 10:05:35 CDT