Re: why does this statement take so long to return?

From: gdas <gdas1NOgdSPAM_at_yahoo.com.invalid>
Date: 2000/06/26
Message-ID: <013b80b8.1e5f63d6@usw-ex0102-013.remarq.com>#1/1

Dave, Sorry about that. Here's a better plan output. Thanks for the help.

Query Plan

---

SELECT STATEMENT Cost = 3237
  SORT GROUP BY
    FILTER

      NESTED LOOPS
        NESTED LOOPS
          NESTED LOOPS
            TABLE ACCESS FULL ORG
            TABLE ACCESS BY INDEX ROWID SUBJECT
              INDEX RANGE SCAN SUBJECT_ORG_ID_IDX
          TABLE ACCESS FULL HIT
        TABLE ACCESS BY INDEX ROWID DATASTAGE
          INDEX RANGE SCAN DATASTAGE_UQ_ID_IDX
      COUNT STOPKEY
        VIEW
          SORT ORDER BY STOPKEY
            SORT GROUP BY
              HASH JOIN
                TABLE ACCESS FULL ORG
                HASH JOIN
                  TABLE ACCESS FULL SUBJECT
                  HASH JOIN

Query Plan

---

                    TABLE ACCESS FULL DATASTAGE
                    TABLE ACCESS FULL HIT

Gavin

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jun 26 2000 - 00:00:00 CDT