Home » RDBMS Server » Performance Tuning » Query regarding deleting the reords from DB
Query regarding deleting the reords from DB [message #228242] Mon, 02 April 2007 04:08 Go to next message
saurabhsoni
Messages: 3
Registered: April 2007
Location: Indonesia
Junior Member

Hi
I am facing a problem while deleting the records from the table which contains more than 10 million records. My delete query is based on joining of two tables.

delete from orignaltable where org_table.time IN ( select time from duplicate_table);

how much time it should take in case I am accessing this DB continuously ???


Thanks

Saurabh

Re: Query regarding deleting the reords from DB [message #228273 is a reply to message #228242] Mon, 02 April 2007 06:22 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>how much time it should take in case I am accessing this DB continuously ???
No one can predict it.
It depends on what you are doing, available statistics,available resources....
Previous Topic: oracle error 35153 temporary tablespace is empty
Next Topic: Does Altering Index Monitoring have Locks
Goto Forum:
  


Current Time: Fri Dec 09 19:21:29 CST 2016

Total time taken to generate the page: 0.10133 seconds