Re: Simple Oracle Query Taking Too Long

One can always come up with hypothetical explanations ... Something like, the table had a very small extent size, the extents are scaterred all over the disk drive, and the first million extents are all empty, and ...

Something that worries me though is you meaningless delete statement ...
"deleting * from abc where rownum <= 1000" You realize that this would delete "any" 1000 rows - and that these rows may not be related to the other 1000 rows you accessed in your previous insert as select statement.

2cents Received on Wed Sep 06 2006 - 15:17:46 CDT