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>
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-lReceived on Tue Apr 01 2008 - 08:24:55 CDT