Re: Explain Plan Problem

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Fri, 4 Feb 2000 09:52:30 +0100
Message-ID: <OoRMV0ub$GA.301@net025s>

Yes, execute the EXPLAIN PLAN command (look in the Oracle Tuning Guide)

Jaap.

Parvinder Singh heeft geschreven in bericht <389A73BC.9D5B8547_at_questone.com>...
>Hi all
>
>can anyone tell me how to get the total explain plan of the query
>without practically executing it ???
>
>Regards
>~Parvinder
>
Received on Fri Feb 04 2000 - 02:52:30 CST

This message: [ Message body ]
Next message: Kræn David Christensen: "Problem with OCI on Oracle 8.1.5 with binding PL/SQL cursors to a OCIStmt handle"
Previous message: Steven Price: "Materialised Views"
In reply to: Parvinder Singh: "Explain Plan Problem"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US