在哪些情况下Oracle会自动创建索引? [英] In which cases will Oracle create indexes automatically?
本文介绍了在哪些情况下Oracle会自动创建索引?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
据我所知(此页)Oracle为每个UNIQUE或PRIMARY KEY声明自动创建一个索引。
As far as I know (this page) Oracle automatically creates an index for each UNIQUE or PRIMARY KEY declaration. Is this a complete list of cases when indexes are created automatically in Oracle?
推荐答案
我将尝试整合给定的答案,并使
因此,Oracle会自动为这种情况创建索引:
I'll try to consolidate given answers and make it community wiki.
So indexes are automatically created by Oracle for such cases:
- APC :用于主键和唯一键,除非此类索引已存在。
- APC :适用于LOB存储和XMLType。
- Gary :对于具有嵌套表格的表格。
- Jim Hudson :实体化视图。
- APC: For primary key and unique key unless such indexes already exist.
- APC: For LOB storage and XMLType.
- Gary: For table with a nested table.
- Jim Hudson: For materialized view.
这篇关于在哪些情况下Oracle会自动创建索引?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文