Re: Efficient Views..

In article <CqzH0s.JDw_at_brunel.ac.uk>, cs91dnm_at_brunel.ac.uk (David N McCann) writes:
>
> There is (or at least was in Sun OS Oracle 6.0.32) a facility to find out how
> the RDBMS was going to process a query. You had to create a special table and
> then do a query on it. I can't remember exactly how, and I can't find it now
> in the 7 or so manuals I've just looked thorugh, but I don't think I dreamed
> it.
>

The facility is EXPLAIN PLAN. You have to create a PLAN_TABLE to store the output from the explain. The script to create the plan table is in ORA_RDBMS:UTLXPLAN.SQL (VMS) or $ORACLE_HOME/rdbms/admin/utlxplan.sql (UNIX).

Explain plan is well documented in the Concepts, Application Developers, and Performance Tuning Guides.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285