Somebody knows for a Informix Tool or a 3rd Party Tool that allows me to prevent or show when Informix performance goes down.
Let me explain : we have recently find some tables (with a lot of records) that become slow in their access. if we download and upload the tables, their becomes fast.
So How can I know were is time to do this process (download and upload) or Do I Have to do this periodically (weekly, dialy) ?
any Tips or recommendations on performance tunning is welcome. Thanks in advance