Thanks Ales,

There are no triggers present on this table. Referential integrity also not present.

Interstigly, while doing the select on this table the data is accessed by db file scattered reads.

db file sequential read occured only for the delete query !!! These single block reads are causing delay.