Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sybase IQ taking unexpectedly long to start query execution

Hello All,

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.

Cheers,

NeM

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question