Oracle >


1.instance level : 세팅(파라미터) 파일에서 설정
# choose(RBO/CBO 자동 선택), first_rows_숫자(CBO), all_rows, first_rows(CBO)
optimizer_mode = rule(RBO)

2.session level
alter session set optimizer_mode=

3.statement level
select /*+ ... */ 
Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2009-12-08 16:40:09
Processing time 0.0067 sec