Re: Tuning Views

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: Wed, 13 May 1998 19:41:13 +0200
Message-ID: <3559DB39.4906B0BF@ubs.com>

tlp_at_redrockgrp.com wrote:
>
> I'm looking for tips in tuning views...
>
> Specifically, I have a view that contains a union. When I do a
> simple 'select' from that view it responds promptly. If I try
> to attach an 'order by' clause it takes some time to respond.
>
> I have a feeling that I need to create a temporary table with a
> view on top of that in order to achieve the results I need BUT
> I figured I would request ideas from you folks first...
>
> Thanks for the input,
> Tracy (tlp_at_redrockgrp.com)

First check the statements via explain-plan. Second check if the sort(order by clause) is done in the memory or on the discs.
(select name, value from v$sysstat where name like 'sorts%').

rgds
eugen Received on Wed May 13 1998 - 12:41:13 CDT