Re: They wanna know why it takes so long .....

Here's most of the explain plan ....

SELECT STATEMENT Hint=CHOOSE
  SORT UNIQUE
    MERGE JOIN OUTER

      MERGE JOIN OUTER
        MERGE JOIN OUTER
          MERGE JOIN OUTER
            MERGE JOIN OUTER
              SORT JOIN
                VIEW
                  FILTER
                    NESTED LOOPS OUTER
                      NESTED LOOPS
                        HASH JOIN
                          TABLE ACCESS FULL
                          NESTED LOOPS
                            MERGE JOIN
                              SORT JOIN
                                MERGE JOIN
                                  NESTED LOOPS
                                    MERGE JOIN
                                      SORT JOIN
                                        MERGE JOIN
                                          SORT JOIN
                                            MERGE JOIN
                                              MERGE JOIN
                                                MERGE JOIN
                                                  MERGE JOIN
                                                    SORT JOIN
                                                      HASH JOIN
                                                        TABLE ACCESS
                                                        FULL
                                                        NESTED LOOPS
                                                          MERGE JOIN
                                                            SORT JOIN
                                                              HASH JOIN
                                                                TABLE
                                                                ACCESS
                                                                FULL
                                                                MERGE
                                                                JOIN
                                                                  SORT
                                                                  JOIN
                                                                    HASH
                                                                    JOIN
                                                                      TA
                                                                      BL
                                                                      E
                                                                      AC
                                                                      CE
                                                                      SS
                                                                      FU
                                                                      LL
                                                                      ME
                                                                      RG
                                                                      E
                                                                      JO
                                                                      IN

MERGE JOIN MERGE JOIN SORT JOIN HASH JOIN HASH JOIN NESTED LOOPS NESTED LOOPS NESTED LOOPS TABLE ACCESS FULL TABLE ACCESS BY INDEX ROWID INDEX RANGE SCAN INDEX UNIQUE SCAN INDEX UNIQUE SCAN TABLE ACCESS FULL VIEW NESTED LOOPS NESTED LOOPS TABLE ACCESS FULL INDEX UNIQUE SCAN INDEX UNIQUE SCAN SORT JOIN TABLE ACCESS FULL SORT JOIN TABLE ACCESS FULL SORT JOIN TABLE ACCESS FULL

                                                                  SORT
                                                                  JOIN
                                                                    TAB-
                                                                    LE
                                                                    ACC-
                                                                    ESS
                                                                    FULL
                                                            SORT JOIN
                                                              TABLE
                                                              ACCESS
                                                              FULL
                                                          INDEX UNIQUE
                                                          SCAN
                                                    SORT JOIN
                                                      TABLE ACCESS FULL
                                                  SORT JOIN
                                                    TABLE ACCESS FULL
                                                SORT JOIN
                                                  TABLE ACCESS FULL
                                              SORT JOIN
                                                TABLE ACCESS FULL
                                          SORT JOIN
                                            TABLE ACCESS FULL
                                      SORT JOIN
                                        TABLE ACCESS FULL
                                    INDEX UNIQUE SCAN
                                  SORT JOIN
                                    TABLE ACCESS FULL
                              SORT JOIN
                                TABLE ACCESS FULL
                            TABLE ACCESS BY INDEX ROWID
                              INDEX UNIQUE SCAN
                        TABLE ACCESS BY INDEX ROWID
                          INDEX UNIQUE SCAN
                      TABLE ACCESS BY INDEX ROWID
                        INDEX UNIQUE SCAN
                    SORT AGGREGATE
                      HASH JOIN
                        NESTED LOOPS
                          NESTED LOOPS
                            TABLE ACCESS BY INDEX ROWID
                              INDEX RANGE SCAN
                            INDEX UNIQUE SCAN
                          TABLE ACCESS BY INDEX ROWID
                            INDEX UNIQUE SCAN
                        TABLE ACCESS FULL
              SORT JOIN
                VIEW
                  NESTED LOOPS
                    NESTED LOOPS
                      NESTED LOOPS
                        NESTED LOOPS
                          HASH JOIN
                            HASH JOIN
                              HASH JOIN
                                HASH JOIN
                                  TABLE ACCESS FULL
                                  HASH JOIN
                                    HASH JOIN
                                      HASH JOIN
                                        HASH JOIN
                                          TABLE ACCESS FULL
                                          TABLE ACCESS FULL
                                        TABLE ACCESS FULL
                                      TABLE ACCESS FULL
                                    TABLE ACCESS FULL
                                TABLE ACCESS FULL
                              TABLE ACCESS FULL
                            TABLE ACCESS FULL
                          INDEX UNIQUE SCAN
                        INDEX UNIQUE SCAN
                      INDEX UNIQUE SCAN
                    INDEX UNIQUE SCAN
            SORT JOIN
              TABLE ACCESS FULL
          SORT JOIN
            VIEW
              NESTED LOOPS
                NESTED LOOPS
                  NESTED LOOPS
                    NESTED LOOPS
                      HASH JOIN
                        HASH JOIN
                          TABLE ACCESS FULL
                          HASH JOIN
                            TABLE ACCESS FULL
                            TABLE ACCESS FULL
                        TABLE ACCESS FULL
                      INDEX UNIQUE SCAN
                    INDEX UNIQUE SCAN
                  INDEX UNIQUE SCAN
                INDEX UNIQUE SCAN
        SORT JOIN
          VIEW
            NESTED LOOPS
              NESTED LOOPS
                NESTED LOOPS
                  NESTED LOOPS
                    NESTED LOOPS
                      HASH JOIN
                        HASH JOIN
                          HASH JOIN
                            TABLE ACCESS FULL
                            HASH JOIN
                              HASH JOIN
                                HASH JOIN
                                  HASH JOIN
                                    TABLE ACCESS FULL
                                    TABLE ACCESS FULL
                                  TABLE ACCESS FULL
                                TABLE ACCESS FULL
                              TABLE ACCESS FULL
                          TABLE ACCESS FULL
                        TABLE ACCESS FULL
                      INDEX UNIQUE SCAN
                    INDEX UNIQUE SCAN
                  INDEX UNIQUE SCAN
                INDEX UNIQUE SCAN
              INDEX UNIQUE SCAN

--
Posted via http://dbforums.com