Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! This group by stmt takes AGES
"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:<aab0o4$t1a$1_at_news.mch.sbs.de>...
> Hi Frank,
>
> did you analyzed space_values? I saw cases where the RBO selected a
> nested-loop with 2 full-table-scans. This is usually _very_ expensive. Even
> more if the inner table is a dictionary view.
> CBO (used if tables are analyzed) probably will choose a hash join for this
> query.
>
> Another solution might be to create a temporary copy of dba_tables, index it
> properly and use this table for your space evaluation.
>
> Regards
> Stephan
hi again,
yes i actually analyzed it (with all indexes, too) right before execution.
regards, frank zaum Received on Fri Apr 26 2002 - 08:40:01 CDT