Home » RDBMS Server » Performance Tuning » any option for this query (10g)
any option for this query [message #686331] Thu, 28 July 2022 22:55 Go to next message
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);
Re: any option for this query [message #686332 is a reply to message #686331] Fri, 29 July 2022 00:25 Go to previous message
Michel Cadot
Messages: 68258
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.

Previous Topic: Time metrics in V$SQL don't add up
Next Topic: Performances and tuning
Goto Forum:
  


Current Time: Fri Aug 12 18:48:29 CDT 2022