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 -> Getting 100 or so rows back fast

Getting 100 or so rows back fast

From: <sergey_s_at_my-deja.com>
Date: 2000/07/23
Message-ID: <8lf0a9$upl$1@nnrp1.deja.com>#1/1 






I have a table of about 3 billion rows partitioned in Oracle 8. Soon, I
will need to run some tests and will need sample data for that from the
big table (maybe 100 rows or so).



Getting rows by ROWNUM is apparently so slow that I get tired of waiting
for the resultset.



How can I create a test table and populate it with 100 rows from the big
table fast?



Thank you!



Sergey




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Sun Jul 23 2000 - 00:00:00 CDT












Original text of this message













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