How do u know it is that Order By that is Killing this Query .. Did u try a
Explan Plan on that ...
Cheers,
Ganesh R
-----Original Message-----
From: Deepa S. Kale
[mailto:oracledba-ezmlmshield-x87778460.[Email address protected]
Sent: 15 July 2004 10:45
To: LazyDBA Discussion
Subject: order by is slow
select vc_comp_code ,dt_voucher_date,vc_voucher_no,nu_account_code from
dt_transaction
where vc_comp_code='01'
and dt_voucher_date between '01-APR-2003' and '31-MAR-2004' and
nu_account_code in ( select nu_account_code
from mst_account
where vc_comp_code='01'
and vc_bank_code is NOT NULL )
and nu_serial_no=0 order by nu_account_code;
if i give order by its very slow... i hav enough sort_area_size :
|-------------------------------------------------+--------------+----------
------|
| sort_area_retained_size | integer | 133120
|
|-------------------------------------------------+--------------+----------
------|
| sort_area_size | integer | 133120
|
|-------------------------------------------------+--------------+----------
------|
| sort_multiblock_read_count | integer | 2
|
|-------------------------------------------------+--------------+----------
------|
i hav 2 temporary tblspace... and i m on 8.1.7....
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.
Internet communications are not secure and therefore the Barclays
Group does not accept legal responsibility for the contents of this
message. Although the Barclays Group operates anti-virus programmes,
it does not accept responsibility for any damage whatsoever that is
caused by viruses being passed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of the
Barclays Group. Replies to this email may be monitored by the Barclays
Group for operational or business reasons.
------------------------------------------------------------------------
Oracle LazyDBA home page