Cost info in Explain Plan

2003-06-05 Thread 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eric

RE: Cost info in Explain Plan

2003-06-05 Thread Eric Mortensen
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