Home » SQL & PL/SQL » SQL & PL/SQL » SQL Tuning Topics
SQL Tuning Topics [message #296591] Mon, 28 January 2008 06:19 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,

I am little confused with the SQL tuning topics.

As far as my knowledge is concerned the SQL tuning topics covers
1. Checking Explain Plan
2. Using Indexes
3. Using Hints
4. ADDM reports
5. Checking Joins
6. Checking ordering in SQL statements

Please guide me am i thinking right?

Or please guide/give me any links so that i will surf and search into it.

Thanks in advance.
Re: SQL Tuning Topics [message #296600 is a reply to message #296591] Mon, 28 January 2008 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ checking the business rule
2/ checking the utility
3/ checking the frequency

Regards
Michel
Re: SQL Tuning Topics [message #296614 is a reply to message #296591] Mon, 28 January 2008 07:17 Go to previous messageGo to next message
deviji
Messages: 23
Registered: November 2007
Junior Member
hi
you can check this web site for topics
http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D17265GC10&p_org_id=28&lang=US&source_call=

then you can get the contents from books or other websites.

regards,
viji
Re: SQL Tuning Topics [message #296630 is a reply to message #296591] Mon, 28 January 2008 08:06 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks for your suggetions.

But the link which is provided is payable.
Please tell me if any other links available.

[Updated on: Mon, 28 January 2008 23:59]

Report message to a moderator

Previous Topic: Call a package dynamically in a procedure
Next Topic: from child to parent node!!
Goto Forum:
  


Current Time: Sat Dec 10 11:05:58 CST 2016

Total time taken to generate the page: 0.24544 seconds