OraFAQ Forum: Performance Tuning » Query performance tuning for ETL

Home » RDBMS Server » Performance Tuning » Query performance tuning for ETL (Oracle 11g)

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

Query performance tuning for ETL [message #584110]

Wed, 08 May 2013 14:32

Pms_SARA07
Messages: 3
Registered: May 2013
Location: Trichy

Junior Member

Hai guys, can you please list the scenarios and solution to improve the performance of complex queries to extract data.

Report message to a moderator

Re: Query performance tuning for ETL [message #584112 is a reply to message #584110]

Wed, 08 May 2013 14:35

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With such a question you can write a book and even then you will not cover all the scenarios taking into account that solutions depend on rdbms version.

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

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

Regards
Michel

[Updated on: Wed, 08 May 2013 14:36]

Report message to a moderator

Re: Query performance tuning for ETL [message #584117 is a reply to message #584112]

Wed, 08 May 2013 14:59

Pms_SARA07
Messages: 3
Registered: May 2013
Location: Trichy

Junior Member

Hi michel, thanx for your quick and strong reply.
Since I am new to data warehousing, I haven't come across many.
As you suggested I will read and make use of those in my project.

Report message to a moderator

Previous Topic:	Does partitioning need constraints to be copied
Next Topic:	delete is very slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 16:00:19 CST 2024