Re: Many tables in a view.

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Tue, 23 May 2000 11:31:09 +0200
Message-Id: <10506.106341@fatcity.com>

Try removing the outer-joins. I know the results aren't what they should be, but at least you can find out if that's the problem. Next, try the hint for Rule-based optimizer, and watch the difference in the explain.
Last of my suggestions; Break this view into some different views. Maybe sometimes not all fields need to be retrieved. If you can save some joins, it may relieve the database a bit?

Eric Lansu

Original Message ----- From: "Jack van Zanen" <nlzanen1_at_ey.nl> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, 23 May 2000 10:53 Subject: Re: Many tables in a view.

>
>
>
> Hi All,
>
>
> Just to give you some additional info:
>
> This is one of the views they came up with and doesn't perform very well.
>
> The second view is from the where clause of the first
Received on Tue May 23 2000 - 04:31:09 CDT