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

Report message to a moderator

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: 10708
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....

Report message to a moderator

Previous Topic: oracle error 35153 temporary tablespace is empty
Next Topic: Does Altering Index Monitoring have Locks
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 01:38:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.