|
-
Thanks hunnies....anyway my brilliant mind got an answer for me
Did u know that pl/sql reading 300,000 EMP rows took 2hrs? to process
simple select?
But when i use this:
insert into temp select decode(rownum,119823,rowid,'') from EMP;
DELETE FROM TEMP where a_rowid is null:
just 5 seconds!
Last edited by jennifer2007; 05-12-2007 at 05:09 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote