Dear All,

I am using Sybase ASE 12.5 ad the below statement is taking hours to execute a delete on a table having 4000000 records even though the correct index is viewed by the delete statement:


DELETE FROM TABLEX WHERE YEAR=2007 AND MONTH <12


It is accessing the index ind(YEAR,MONTH) on TABLEX.

Does anybody has an idea how to improve the performance of this statement please.


Thanks .

try to delete the rows in some batches
ie delete from tablex where YEAR=2007 and Month=1
delete from tablex where YEAR=2007 and Month=2
delete from tablex where YEAR=2007 and Month=3
.... delete from tablex where YEAR=2007 and Month=11

May be this will reduce the execution time