We have IQ 16.1 on AIX and hundreds of tables in it, since this is POC we use default settings of IQ, with no specific parameter switches.
I have noticed that few SQL with the same structure runs much slower compared to other ones, 3 minutes and more compared to 6-10 seconds. There are default HG indexes on Join columns and nBIT of rest of them
The performance leak, at least I think so, is because of one table, because if we use this table, then performance goes down. So, I dropped it and created/loaded with data once again and suddenly no performance issues - all queries runs perfectly fine.
I have seen this now and then, and always i recreate the table and get this resolved, but it should not be like this.
What could be wrong with this picture?