티스토리 뷰

  • init.ora

QUERY_REWRITE_INTEGRITY=TRUSTED
QUERY_REWRITE_ENABLED=TRUE
COMPATIBLE >  8.1.0.0.0

  • privilege

CREATE INDEX /QUERY REWRITE /CREATE ANY INDEX
GLOBAL QUERY REWRITE.

  • CBO (Cost Based Optimizer)

 Create statistics information by using analyze or use the index by using hint.

  • RBO (Rule Based Optimizer)

 Function based index cannot be used in RBO. If the optimizer mode is Choose, the table should be analyzed.

공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2025/08   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함