Re: Tuning for IN subquery
From: L120bj <l120bj_at_aol.com>
Date: 2000/05/30
Message-ID: <20000530125737.07197.00000760_at_ng-bd1.aol.com>#1/1
Date: 2000/05/30
Message-ID: <20000530125737.07197.00000760_at_ng-bd1.aol.com>#1/1
Dave,
[Quoted] 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