Re: Tuning for IN subquery

Rob,

    Unfortunately, our partition_view_enabled parameter is set to FALSE although I could change my view to use UNION ALLs. It is not easy to get init parameters changed in our environment, which is 7.3.2.3.2. I'll try the package and cursor first but will check on getting the init parameter changed.

    Thanks again for the useful information. Dave

L120bj wrote:

> Dave,
> Wrt my last message and the init.ora parameter. The views we defined used
> UNION ALL rather than UNION, since we could guarantee that the rows in each
> table comprising the view were not duplicated in any of the other tables. If
> your view does not use UNION ALL then I don't think the init.ora parameter will
> make any difference. It may, however, be worth checking whether the view could
> be changed to a UNION ALL view.
> Regards,
> Rob
Received on Tue May 30 2000 - 00:00:00 CEST