RE: Cost info in Explain Plan

2003-06-06 Thread Whittle Jerome Contr NCI
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

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