Does where condition in delete statement looks for an index
for example:
delete from mytable where insertedon>='2015/02/01'
if there is no index on mytable does it go for table scan (among millions of records)
as per my understanding (please correct me if i am wrong) , if there is no index on a table then DML operation will work fast as there is no index maintenance.
Thanks,
Manish
Bulbul AhmedPosted Nov 1, 2016, 8:45 AM
Manas MohapatraPosted Nov 1, 2016, 8:42 AM
Bikesh SrivastavaPosted Nov 1, 2016, 8:41 AM