Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-zo server option Next Page

-zp server option


Turns on capturing of the plan most recently used by the query optimizer.

Syntax

{ dbsrv10 | dbeng10 } -zp ...

Applies to

All operating systems and servers.

Remarks

Include this option if you want the database server to store the query execution plan that was used most recently by each connection. This feature can also be turned on using the RememberLastPlan server setting with the sa_server_option system procedure. You can view the text of the most recently-used plan by using the LastPlanText connection property.

See also