Resolve Dependencies of Function-Based Indexes (205)
A function-based index depends on any function that it is using. If the function or
the specification of a package containing the function is redefined (or if the index owner’s
EXECUTE privilege is revoked), then the following conditions hold:
■ The index is marked as DISABLED.
■ Queries on a DISABLED index fail if the optimizer chooses to use the index.
■ DML operations on a DISABLED index fail unless the index is also marked
UNUSABLE and the initialization parameter SKIP_UNUSABLE_INDEXES is set to
true.
To re-enable the index after a change to the function, use the ALTER INDEX ... ENABLE
statement.
解決函式索引的依賴性
1. 如果函式索引中的函式或者包含該函式的包重新定義 ,以及索引擁有者的EXECUTE許可權被回收 ,則
a. 索引被標記為失效
b. 最佳化器如果選擇使用索引 , 利用該索引上的查詢失效
c. 如果索引被標記為UNUSABLE , 或者初始化引數SKIP_UNUSABLE_INDEXES為true , 則失效索引上的dml操作是失敗的
2. 當函式變更後 , 可以使用ALTER INDEX ... ENABLE來使索引ENABLE
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982491/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Dependencies of Function-Based Indexes (202)FunctionIndex
- 建立Function-Based IndexesFunctionIndex
- Function-Based Indexes (199)FunctionIndex
- Uses of Function-Based Indexes (200)FunctionIndex
- Optimization with Function-Based Indexes (201)FunctionIndex
- 高效的SQL(Function-based Indexes 函式、運算優化思路)SQLFunctionIndex函式優化
- 使用自定義函式創Function-Based Indexes時需要使用DETERMINISTIC Functions!函式FunctionIndex
- Function-based Index and Or-ExpansionFunctionIndex
- Rebuild IndexesRebuildIndex
- ORACLE INDEXESOracleIndex
- Injection of autowired dependencies failed;AI
- Fine Grained DependenciesAI
- dba_dependencies scripts
- Management of Remote Dependencies (252)REM
- Dependencies of Applications (256)APP
- Dependencies and Views (180)View
- Codeforces #205前三題
- CPT205 Computer Graphics
- 讀懂 gradle dependenciesGradle
- Resolution of Schema Object Dependencies (241)Object
- Oracle - Tables/IndexesOracleIndex
- Reverse Key IndexesIndex
- ORACLE -> NULL & INDEXESOracleNullIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Global Nonpartitioned IndexesIndex
- Extents in Indexes (19)Index
- 翻譯(九)——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- 關於函式索引(function-based index)函式索引FunctionIndex
- dependencies 和 devDependencies 的異同dev
- Dependencies for Graphs 閱讀筆記筆記
- skip_unusable_indexesIndex
- The Secrets of Oracle Bitmap IndexesOracleIndex
- Restrictions on Create Bitmap IndexesRESTIndex
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Overview of Indexes (194)ViewIndex