OraFAQ Forum: SQL & PL/SQL » Performance of Window Sort

Home » SQL & PL/SQL » SQL & PL/SQL » Performance of Window Sort (Oracle 11g)

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

Performance of Window Sort [message #613593]

Thu, 08 May 2014 06:56

orc_dev
Messages: 2
Registered: August 2012
Location: gfdg

Junior Member

Hi,

I am using MAX function in my query, which takes more cost (around 1,90,0000)
SELECT * FROM (SELECT Balance, product_id,
MAX(Balance) OVER(PARITION BY a.link_id,a.exp_value, a.party_id) as Max_balance
key,
range
from table_a a , table_b b
where a.id = b.id )X
where Balance = Max_balance

Is there any way to reduce execution time of this query?

Report message to a moderator

Re: Performance of Window Sort [message #613597 is a reply to message #613593]

Thu, 08 May 2014 07:06

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

Senior Member
Account Moderator

You didn't feedback nor answer our questions in your previous topic, I do not help you in this one.
Learn to have a correct behaviour in the world.

Report message to a moderator

Re: Performance of Window Sort [message #613603 is a reply to message #613593]

Thu, 08 May 2014 07:58

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Menastec wrote on Thu, 08 May 2014 17:26

Is there any way to reduce execution time of this query?

How could someone tune a query just by looking at it? No test case, no information. You did not follow even the minimal forum rules in order to help you.

Report message to a moderator

Previous Topic:	Strange Pivot - Concatenate Text Fields
Next Topic:	Bulk insert and record missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:02:59 CDT 2024