OraFAQ Forum: Performance Tuning » any option for this query

Home » RDBMS Server » Performance Tuning » any option for this query (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

any option for this query [message #686331]

Thu, 28 July 2022 22:55

rnemkul
Messages: 35
Registered: February 2006

Member

I have following query and this query execute more than 300 times at execute of report ant it become slow is any option so i am pleasure

SELECT SUM(a.amount)
FROM vw_gledger a
WHERE fiscal_yr='2016/17'
AND a.tdate BETWEEN '16-jul-16' AND '16-jul-17'
AND a.comm_cd IN (SELECT comm_cd FROM tbl_common_mst START WITH comm_cd ='1'
CONNECT BY PRIOR comm_cd = mgr_comm_cd);

Report message to a moderator

Re: any option for this query [message #686332 is a reply to message #686331]

Fri, 29 July 2022 00:25

Michel Cadot
Messages: 68343
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

From your previous topics:

cookiemonster wrote on Mon, 30 September 2013 13:34

1) Please read and follow How to use [code] tags and make your code easier to read?
...

BlackSwan wrote on Thu, 23 January 2014 16:23

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

And FEEDBACK in your topics currently we have about... 0 feedback from you.

Report message to a moderator

Previous Topic:	Time metrics in V$SQL don't add up
Next Topic:	Sql behaving badly after upgrade (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 01 05:48:13 CST 2023