Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long

Re: Simple Oracle Query Taking Too Long

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 6 Sep 2006 13:17:46 -0700
Message-ID: <1157573866.203345.192090@p79g2000cwp.googlegroups.com>


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

Original text of this message

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