Skip to Content
Jan 03, 2018 at 06:35 AM

Sybase IQ 16.1 issue



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?