Hi Listers,
I have the below query which takes 36 sec. to execute:
SELECT /*+ordered*/
S.HOUSEBILL,
OH.ORDER_REF_NO,
V.CONTAINER_NUM,
S.AEI_REFERENCE,
CE1.SEQUENCE,
TL1.COMPONENT_VALUE,
TL2.COMPONENT_VALUE,(
SELECT
to_char(SCT1.TIMESTAMP,
Ranganath
I notice that the cost for the explain plan is identical. Keep in mind
that the explain plan is a good quick look at how Oracle intends to perform
the query, but is not an actual execution. It can be fooled, and even make
bad choices. When I encounter a query where explain plan isn't
Raj - If someone hasn't previously used tkprof, in your opinion should they
start with this utility, or with tkprof and work their way to this?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, February 03, 2003 9:40 AM
To: Multiple
Title: RE: Query takes more time when number of IN List value increases
Also see
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT_id=224270.1 this makes it easy ...
Raj
__
Rajendra Jamadagni MIS
Title: RE: Query takes more time when number of IN List value increases
Dennis,
I am not an expert, but I find this utility gives a (relatively) readable output compared to tkprof. I use both, but for starters I'd say, look at both and see what you like. This utility doesn't use tkprof