Home » RDBMS Server » Performance Tuning » High optimizer cost ..Please help me out to tune the query. (merged 4)
High optimizer cost ..Please help me out to tune the query. (merged 4) [message #383305] Wed, 28 January 2009 03:36 Go to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Please help me out to tune the below query.Here i have attached both the sql and explain plan as an attachment.

Regards,
Dhanalakshmi.P
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #383309 is a reply to message #383305] Wed, 28 January 2009 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Do not repost the same question every 4 minutes.
If you have any problem, check the forum BEFORE reposting.

Regards
Michel
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #383310 is a reply to message #383305] Wed, 28 January 2009 03:56 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Thanks for your information.
Please find the attached explain plan for the sql.


regards,
dhanalakshmi.P
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #383315 is a reply to message #383310] Wed, 28 January 2009 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You already posted it 4 times the 5th one is useless.

Regards
Michel
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #384058 is a reply to message #383310] Mon, 02 February 2009 00:57 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
waiting for your reply


regards,
Dhanalakshmi.P
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #384133 is a reply to message #383305] Mon, 02 February 2009 04:54 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
If you think that it's OK to post unformatted EXPLAIN of 172 rows, keep waiting.

[Updated on: Mon, 02 February 2009 04:55]

Report message to a moderator

Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #384161 is a reply to message #383305] Mon, 02 February 2009 07:17 Go to previous message
cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester
Senior Member
So you've got a query that is union of three queries against a view.
You haven't given us a definition of that view.
You haven't given us definitions of the underlying tables.
You haven't even given us a readable explain plan.

If you want anything approaching usefull help you're going to have to provide us with all of the above.

That said, you're going to struggle to make a query that unions a view 3 times then groups the result and sorts it run fast.
Previous Topic: best performance quries
Next Topic: SQL performance Tuning help
Goto Forum:
  


Current Time: Sat Dec 14 13:01:52 CST 2024