|Oracle8i interMedia Text Migration
Release 2 (8.1.6)
Part Number A77061-01
Querying, 12 of 12
With query explain plan, formerly known as query expression feedback, you can obtain an execution plan of a Text query before actually issuing the query. Oracle returns the explain plan information in a table, from which you can construct a parse tree.
In interMedia Text 8.1, this feature has been renamed from query expression feedback to query explain plan. Query explain plan should not be confused with hierarchical query feedback, which is a new, different feature.
The user interface for query explain plan has changed in the following ways:
You use the CTX_QUERY.EXPLAIN to obtain expression feedback. The procedure for obtaining this information has not changed from pre-8.1 to 8.1. You must do the following:
You must use the new 8.1 explain syntax when you code the first three steps.
The way you construct and expansion tree from the explain table in step 4 is the same as in pre-8.1
For examples on constructing the expansion tree, see the CTX_QUERY.EXPLAIN command syntax in the Oracle8i interMedia Text Reference.