Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    3

    Sybase Performance Tuning

    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 .

  2. #2
    Join Date
    Mar 2008
    Posts
    96
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •