Title: RE: Cost info in Explain Plan
Eric,
Don't you hate it when that happens!
You also won't see cost info if you are using the Rule hint naturally enough.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From
Hello world,
Can anyone explain (forgive the pun) how to get cost/card/bytes information out of the
Explain Plan? I'm using Toad and sometimes it gives me cost info and sometimes it
doesn't. Why?
Regards,
Eric
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eric
It just occurred to me why - it's the analyze, stupid! One of my tables wasn't
analyzed.
:-) Eric
-Original Message-
From: Eric Mortensen
Sent: Thu 05.06.2003 10:48
To: [EMAIL PROTECTED]
Cc:
Subject: Cost info in Explain Plan