Multiple choice technology databases

Sybase IQ query optimizer generates a query plan for every query. When I set the QUERY_PLAN option ON, where is the query plan sent to?

  1. html file

  2. iqmsg file

  3. iqplan file

  4. log file
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When QUERY_PLAN option is enabled, Sybase IQ writes the generated query plan to the iqmsg file, which is the standard message log file. This file contains diagnostic information including query plans for optimization analysis.

Keep practicing — related questions