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: Eric Mortensen [SMTP:[EMAIL PROTECTED]
It just occurred to me why - it's the analyze, stupid! One of my tables wasn't analyzed.
:-) Eric
-----Original Message-----
From: Eric Mortensen
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