Re: Help! This group by stmt takes AGES

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Mon, 29 Apr 2002 10:32:46 +0200
Message-ID: <aaj0fg$gkd$1@news.mch.sbs.de>

Hi Frank,

I think we need some more execution details here.

Please run your query with sqltrace and provide the tkprof output (including the execution plan).

Another idea regarding your table space_values: You state there are only 800 rows contained in that table. Is it possible that it was much larger in the past (you know, big HWM which affects full-table-scans).

Regards
Stephan Received on Mon Apr 29 2002 - 03:32:46 CDT

This message: [ Message body ]
Next message: Saikat Chakraborty: "Re: Question about Undo segments"
Previous message: Ariel: "Linguistic indexes and 'order by' won't work..."
In reply to: Frank Zaum: "Re: Help! This group by stmt takes AGES"
Next in thread: warren: "Re: Help! This group by stmt takes AGES"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US