Re: HELP Query never completes

Have you tried EXPLAIN PLAN to see what the optimizer thinks it's going to do with your query?

Michael Joseph wrote:
>
> The following query causes our 1Gb TEMP tablespace to overflow with the
> 'Unable to extend TEMP tablespace' message and consequently cannot be
> run to completion.
>
> We have analysed it up and down but to no avail.
>
> Here are some other Stats:
>
> The tables are all under 100,000 rows with the exception of the _AW
> table which is about 6,000,000 rows.
> All the joined columns are indexed in single key indexes.
> All the _AW indexes are bitmaps
> Not all the group by columns are indexed but indexing them seems to make
> no difference.
>
> Thanks for any help.

%<snip>%

               DataWeb Consulting Services, Inc.
              "Web-enabling your databases today"
voice:(303)517-3863                       FAX:(303)422-5107
                       gkainz_at_rmi.net
------------------------------------------------------------