on 04-12-2016 2:31 PM
Hi,
I am an Oracle DB developer, new to Sybase IQ DB. I am looking for some help from experts to tune my SQL's.
1)Is there any command to see explain plan in IQ?
2)Is there any generic guidelines to tune large queries in IQ.?
Thank You
Binu Varghese
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Binu,
There a couple of options like QUERY_PLAN, QUERY_DETAIL, to generate query plans (Explain)
Wiki pages below contain guidlines for this purpose
Customer Coffee Corner for SAP IQ - Troubleshooting SAP IQ Query Performance - Part 1 - SAP IQ - SCN...
Customer Coffee Corner for SAP IQ - Troubleshooting SAP IQ Query Performance - Part 2 - SAP IQ - SCN...
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.