Re: Simple Oracle Query Taking Too Long

From: Bryan Hunter <bryan_at_exitexchange.com>
Date: Wed, 6 Sep 2006 13:49:58 -0700
Message-ID: <YvGLg.157794$yf.97457@fe18.usenetserver.com>

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