Sybase IQ taking unexpectedly long to start query execution
I have a situation where Sybase IQ takes too long to start the query execution. I have looked at the execution plans, the actual execution times are just a couple of seconds but the white space or "thinking time" takes over a couple of minutes which results in extremely slow queries. I have seen a couple of runs where the queries took no time at all, and "thinking time" in those cases was only about 200ms.
I'm trying to figure out why there would be soo much "thinking time" before Sybase actually starts the query and how it can be improved. There doesnt seem to be much documentation on sybase iq website about what this "thinking time" actually is.