An information object can be used as a data source in Report Studio. The information object’s query plan is compiled the first time a Report Studio user drags and drops a column from the Available Data pane to the report display area. If the information object is built from a large number of maps or information objects, the first drag-and-drop operation can take a long time. To avoid this problem, you can store a precompiled query plan with the information object.
Storing a precompiled query plan with an information object increases the size of the information object. For this reason, do not store a precompiled query plan with an information object unless the first drag-and-drop operation in Report Studio is unacceptably slow.
Store a precompiled query plan with an information object when either of the following conditions is true:
The information object is built from more than 100 tables consisting of more than 1000 columns.
The information object has more than four levels in its hierarchy.
If an information object query’s compile time is very large, it may be advisable to store a precompiled query plan with the information object.
How to display an information object query’s compile time
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.
A schematic representation of the query execution plan appears in the upper pane of Query Profiler, as well as Profiler Statistics such as compile time. In Figure 3‑56, Profiler Statistics displays a compile time of three seconds.
The information object is built from more than 100 tables consisting of more than 1000 columns.