In article <918226190.3705.0.nnrp-09.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>It seems that the optimizert 'tries very hard' to switch to
>ALL_ROWS optimisation when you use CTAS. (Which
>is quite reasonable, really, since the table is not created
>until all the rows exist).
>
>To get around this, I usually put the tables in the
>order I want them visited, use the ORDERED hint
>and then use the USE_NL hint very liberally. This
>usually works, though sometimes a very explicit
>index hint (including name) helps.
>
Yup, I tried just this after posting the question (that is, using INDEX()
together with USE_NL) and it now works like a charm. Thanks.
G.
Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison
GAverill<at>chsra<dot>wisc<dot>edu
Received on Fri Feb 05 1999 - 14:36:14 CST
