If SQL Anywhere is having difficulty handling a query against a remote table, it is usually helpful to understand how SQL Anywhere is executing the query. You can display remote tracing, and a description of the query execution plan:
SET OPTION cis_option = 7;
Once you have turned on remote tracing, the tracing information appears in the database server messages window. You can log this output to a file by specifying the -o server option when you start the database server.
For more information about using the cis_option option for debugging queries when using remote data access, see cis_option option.
For more information about the -o server option, see -o dbeng12/dbsrv12 server option.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|