1. Performance Tuning Guide
  2. Example of Obtaining a Query Plan

Example of Obtaining a Query Plan

This topic is part of Analyzing Generated SQL for Performance Issues.

The following procedure shows an example of obtaining a query plan when running against a local database using the Siebel Mobile Web Client. It is assumed that customers will obtain query plans using the RDBMS for their enterprise database, such as Oracle Database, IBM DB2, or Microsoft SQL Server.

To obtain a query plan for an SQL statement in your trace file

  1. Log in to the local database, as described in Siebel Remote and Replication Manager Administration Guide.

  2. In order to analyze an SQL statement from the SQL trace file, copy the SQL statement and paste it into the database query tool you are using.

  3. Replace bind variable references with the corresponding bind variable values.

  4. Execute the query.

    The query runs against the local database. The Statistics pane provides analysis information.