Re: Hints used most often?

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Tue, 1 Apr 2008 22:24:55 +0900
Message-ID: <43c2e3d60804010624y97199a3q276d22178b731098@mail.gmail.com>


Very interseting.

Some hints on my list except aboves are (most of them are available as of 10g)

  • gather_plan_statisitcis used as a *handy* sql trace
  • qb_name to specifiy query block name when tuning complex queries
  • dynamic_sampling used as alternative to statistics for large-scale DW queries
  • opt_param this magical hint is added in 10.2.0.3(IIRC). used to control optimizer behavior in query level

Dion Cho

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 01 2008 - 08:24:55 CDT

Original text of this message