Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

6

主题
1#
发表于 2013-11-1 13:51:43 | 查看: 3167| 回复: 2
在官方文档
"Managing Partitioned Table and Indexes"中有一段话如下:


A local index is constructed so that it reflects the structure of the underlying table. It is equipartitioned with the underlying table, meaning that it is partitioned on the same columns as the underlying table, creates the same number of partitions or subpartitions, and gives them the same partition bounds as corresponding partitions of the underlying table. For local indexes, index partitioning is maintained automatically when partitions are affected by maintenance activity. This ensures that the index remains equipartitioned with the underlying table.

对于这个部分不是很清楚,请前辈指点!
2#
发表于 2013-11-1 13:52:16
Oracle 10g r2 文档

回复 只看该作者 道具 举报

3#
发表于 2013-11-5 17:40:56
试着说一下主要意思。本地索引创建时需要和对应表(underlying table)的分区一样(比如一张分区表有12个分区,那创建的本地索引也要12个分区)。
如果有误,请指正。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-2 21:50 , Processed in 0.047742 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569