When the Actuate SQL compiler compiles an information object, the compiler creates one query for each data source. The query is written in the native query language of the data source. You can display the query that is sent to a data source, as well as the following information about the query:
The number of rows in the query’s output
The amount of time it takes to execute the query in milliseconds
The name and path for the data connection definition file
How to display a data source query and information about the query
1 Choose Query Profiler.
2 In Query Profiler, choose Start.
3 On Parameter Values, type the parameter values, as shown in Figure 3‑52. Choose OK.
Figure 3‑52 Providing the parameter values
A schematic representation of the query execution plan appears in the upper pane of Query Profiler.
4 Select a SQL or ODA node to display the data source query.
The data source query appears in the lower pane, as shown in Figure 3‑53.
Figure 3‑53 Displaying the data source query
5 Hover the cursor over the SQL or ODA node to display information about the query. Figure 3‑54 shows an example of the information displayed for a query.