Home » RDBMS Server » Performance Tuning » Query Optimization (merged)
Query Optimization (merged) [message #354806] Tue, 21 October 2008 06:31 Go to next message
psamarpan
Messages: 6
Registered: October 2008
Location: Bangalore
Junior Member
Hi All,

Could you please help me on that optimization query, it will taking more than one hour to this query.

Thank you so much
Optimization [message #354808 is a reply to message #354806] Tue, 21 October 2008 06:36 Go to previous messageGo to next message
psamarpan
Messages: 6
Registered: October 2008
Location: Bangalore
Junior Member
Hi All,

Could you please help me on this query it will taking more than an hour.

Thank you so much

Samarpan
Re: Optimization [message #354814 is a reply to message #354808] Tue, 21 October 2008 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unacceptable post.

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Re: Query Optimization [message #354816 is a reply to message #354806] Tue, 21 October 2008 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your question, post them once but post them correctly.

Regards
Michel
Re: Query Optimization (merged) [message #354869 is a reply to message #354806] Tue, 21 October 2008 13:38 Go to previous message
Kriptas
Messages: 118
Registered: June 2008
Senior Member
I do not undestand some people,
they posts there huge queries, and wants that other people, who do not know logic, tables and etc., do the tuning thing.

in that scenario, I think, they want that other people do they job, but do nto want to learn ;/
Previous Topic: Query running more timeand then time out message
Next Topic: can oracle access table in parallel with index?
Goto Forum:
  


Current Time: Thu Dec 08 00:33:00 CST 2016

Total time taken to generate the page: 0.05502 seconds