Re: Hints used most often?

From: 조동욱 <>
Date: Tue, 1 Apr 2008 22:24:55 +0900
Message-ID: <>

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 used to control optimizer behavior in query level

Dion Cho

Received on Tue Apr 01 2008 - 08:24:55 CDT

Original text of this message