OraFAQ Forum: Performance Tuning » Query Optimization (merged)

Home » RDBMS Server » Performance Tuning » Query Optimization (merged)

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

Query Optimization (merged) [message #354806]

Tue, 21 October 2008 06:31

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

Attachment: ppeltier.ap peltier stats.txt
(Size: 17.72KB, Downloaded 1212 times)

Report message to a moderator

Optimization [message #354808 is a reply to message #354806]

Tue, 21 October 2008 06:36

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

Attachment: ppeltier.ap peltier stats.txt
(Size: 17.72KB, Downloaded 1189 times)

Report message to a moderator

Re: Optimization [message #354814 is a reply to message #354808]

Tue, 21 October 2008 06:52

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Query Optimization [message #354816 is a reply to message #354806]

Tue, 21 October 2008 06:55

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Query Optimization (merged) [message #354869 is a reply to message #354806]

Tue, 21 October 2008 13:38

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 ;/

Report message to a moderator

Previous Topic:	Query running more timeand then time out message
Next Topic:	can oracle access table in parallel with index?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 04:14:32 CDT 2024