var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors