Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long
The table that I am migrating the data to is not relivent to the problem, so
I did not feel that the number of rows or indexing was important just the
process that I was performing.
I did copy a portion of the data to a new table as suggested with no indexing and selecting where rownum = 1, still took almost 1 minute.
The original table has initial extent of 64kb and a 1% increase with unlimited extents
I do not know if I agree with the statement that select the first 1000 rows of a table will result in a different 100 0rows every time as suggested by G Quesnel. I would appreciate any comments on this also. Received on Wed Sep 06 2006 - 15:49:58 CDT
![]() |
![]() |