Re: Ora 9.2 SQL: What's the fastest way to do this set operation...

From: dean <deanbrown3d_at_yahoo.com>
Date: 30 Apr 2006 21:20:41 -0700
Message-ID: <1146457241.170052.28460@u72g2000cwu.googlegroups.com>

Here's the results for rownum < 20: Note it takes 20 secs.

T1 P1 T2 P2 ---------- ---------- ---------- ----------

      1661          1         49          1
      1667          1         49          1
      1727          1         49          1
      1737          1         49          1
      1759          1         49          1
      1760          1         49          1
      1762          1         49          1
      1998          1         49          1
      4228          1         49          1
      4234          1         49          1
      4236          1         49          1
      5696          1         49          1
      5792          1         49          1
      5814          1         49          1
      5837          1         49          1

15 rows selected.

Elapsed: 00:00:20.31 Received on Sun Apr 30 2006 - 23:20:41 CDT

This message: [ Message body ]
Previous message: dean: "Re: Ora 9.2 SQL: What's the fastest way to do this set operation..."
In reply to: dean: "Re: Ora 9.2 SQL: What's the fastest way to do this set operation..."
Next in thread: hansF: "Re: Ora 9.2 SQL: What's the fastest way to do this set operation..."

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