Showing the Execution Plan

Use dbisql to read the execution plan of the code that you are tracing.

  1. If it has not already been done, register the Ultralite ODBC DLL from the SMP_HOME\Servers\SQLAnywhere12\BIN32\ directory by executing:c:\Windows\System32\ regsvr32.exe ulodbc12.dll.
  2. From SMP_HOME\Servers\SQLAnywhere12\BIN32\, execute dbisql. When prompted to connect to a database of a specified type, click Change database type , select UltraLite, and provide connection information.
  3. From the Sybase Central main menu, select Tools > Plan Viewer.
  4. Copy and paste the SQL statement from the trace file obtained previously into the “SQL” area and press Get Plan.
    See Reading UltraLite execution plan in the online help for the version of SQL Anywhere installed as part of SAP Mobile Platform to familiarize yourself with execution plan operations before examining your execution plan.
Parent topic: Improve Object Query Performance