Deleting Rows from Table-Taking too much time
Hi Experts,
i m facing a issue while deleting 2 lak rows from a table. below is the command that i m using to delete rows from a table.
delete from LOGS t where t.time like '20110609%';
why it is taking soo much time. is there any alternate to delete rows from a table in short time.
regards,