Out of Control Comic

Resources Site for Maintaining Oracle® E-Business Suite

Welcome to Damage Control

Damage Control showcases the best resources for maintaining Oracle E-Business Suite but with a comic touch.
So join the community; issue your pickle ratings, add comments, and submit resources. Check out the Help page for navigational tips.

Using Hints in SQLs versus Using Outlines

Posted on: 12/23/2006 @ 03:26PM
By: Navdeep Saini
Many times as DBAs or sometimes developer we need to fix a performance issue and mostly the fix is adding hint/s to the sql. There are two options to put a hint: 1. Put the hint in the sql itself and redeploy the code (works well if it is custom code). 2. Create an outline with hint for [...]
http://practicalappsdba.wordpress.com/2006/12/23/hints/

Comments (Add)

Firm

hints in sqls vs outlines

Navdeep even has a word document attached to his blog that compares both the techniques. Check it out.
Posted by susan on 11/21/2007 @ 12:30PM
Firm

this is great for someone starting out

-s
Posted by susan on 11/21/2007 @ 12:43PM

You must be logged in to comment on an article.

Topics

Tags

  • Untagged!