Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    8

    Unanswered: Informix index usage

    Hi,

    I would like to know which index has been usage and which one never been used.

    Is anybody know how to do this??

    Thanks!!

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    take a look at

    set explain on

    the command will generate a file witch will tell you everything
    about your query

    Cheers

    Artem
    Last edited by artemka; 08-27-04 at 17:29.

  3. #3
    Join Date
    Aug 2004
    Posts
    8
    Thanks Artem,
    But, is there any quickly manner more than "set explain on" to verify index?
    And the unused index would be impact the performance ???

    Thanks!!

  4. #4
    Join Date
    Jun 2004
    Location
    Madrid, Spain
    Posts
    47
    Hi,

    If the index is detached from the table you can check the output from onstat -g ppf. Then you'll match the 'partnum' field with the contents from sysfragments for each database.

    I also think that the output from sysptnhdr/sysptprof in sysmaster will help. Take a try...

    And the answer to your second question is yes: an index is a performance problem for inserts/deletes/updates...

    Hope it helps.
    José Luis Matute.

    Regards from Spain.

  5. #5
    Join Date
    Aug 2004
    Posts
    8

    Talking

    I'll try it,
    Thanks a lot !!

Posting Permissions

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