Home » RDBMS Server » Performance Tuning » Query performance tuning for ETL (Oracle 11g)
icon5.gif  Query performance tuning for ETL [message #584110] Wed, 08 May 2013 14:32 Go to next message
Pms_SARA07
Messages: 3
Registered: May 2013
Location: Trichy
Junior Member
Smile Hai guys, can you please list the scenarios and solution to improve the performance of complex queries to extract data.
Re: Query performance tuning for ETL [message #584112 is a reply to message #584110] Wed, 08 May 2013 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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.
Previous Topic: Does partitioning need constraints to be copied
Next Topic: delete is very slow
Goto Forum:
  


Current Time: Mon Oct 20 16:21:55 CDT 2014

Total time taken to generate the page: 0.12293 seconds