Pre-condition to using Function Based Index
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..
Database/Oracle
2009. 4. 22. 17:02
공지사항
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
링크
TAG
- Maven
- spring
- Guava
- log4j
- EMV
- install
- docker
- ssh
- JSF
- SBM
- Kubernetes
- OOP
- zookeeper
- Heap
- monitoring
- Oracle
- SMPP
- Jose
- Dependency
- nodejs
- dump
- jboss
- svn
- ubuntu
- spring boot
- Shell
- bash
- bouncycastle
- Java
- Tomcat
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
글 보관함