Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: They wanna know why it takes so long .....

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

From: buckeye234 <member13594_at_dbforums.com>
Date: Fri, 14 Mar 2003 15:08:33 +0000
Message-ID: <2643980.1047654513@dbforums.com> 






Here the rest .. sorry for the formatting, the indentation disappeared
when I posted ...



      SORT JOIN
        VIEW
          MERGE JOIN OUTER
            SORT JOIN
              NESTED LOOPS
                MERGE JOIN
                  SORT JOIN
                    HASH JOIN
                      TABLE ACCESS FULL
                      NESTED LOOPS
                        TABLE ACCESS FULL
                        INDEX UNIQUE SCAN
                  SORT JOIN
                    TABLE ACCESS FULL
                INDEX UNIQUE SCAN
            SORT JOIN
              TABLE ACCESS FULL





I just thought this was amazing .....


--
Posted via http://dbforums.com


Received on Fri Mar 14 2003 - 09:08:33 CST












Original text of this message













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