Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Unanswered: fine tuning of Indexes

    We are having 22 indexes built on an informix table. This is used in Peoplesoft. We would like to drop a few indexes which are least useful with respect to the performance of Peoplesoft objects.
    The approach we have is to identify the sqls that may be using the indexes and run Explain on the query. This needs to be done before and after disabling the index.
    We would like to have an alternate approach to identify the least useful tables, which would be less manual and probably use the informix system tables or logs.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: fine tuning of Indexes

    Originally posted by naag007
    We are having 22 indexes built on an informix table. This is used in Peoplesoft. We would like to drop a few indexes which are least useful with respect to the performance of Peoplesoft objects.
    The approach we have is to identify the sqls that may be using the indexes and run Explain on the query. This needs to be done before and after disabling the index.
    We would like to have an alternate approach to identify the least useful tables, which would be less manual and probably use the informix system tables or logs.
    Hi,

    One question: You run update statistics daily ?
    Run update statistics HIGH for header index and MEDIUM for another columns in the index.
    After this, check with explain, the indices used and the sql's used.
    I think that you must aplication check and re write some SQL's.

    Gustavo.

Posting Permissions

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