Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007

    Unanswered: Sybase IQ - Administrative tasks


    I am working on IQ 12.7. Now i have to work on administrative part of IQ. Hence I want to know the different administrative and monitoring tasks that can be done in IQ. (e.g. in ASE, REORG, dbcc commands etc). Like these ASE tasks, i want to know different tasks that can be executed daily/weekly basis.

    Thanks in advance


  2. #2
    Join Date
    Nov 2002
    With IQ, you've a different storage method. Your tables are only a concept (a group of columns).

    So the defragmentation is not necessary.

    You only need to look after the different type of indexes you're using : choosing a bad type will have a significant negative impact.

    So, manage these indexes regarding the number of distinct values you have for each column. Analyze these distinct values periodically...
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

Posting Permissions

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