RT

select GLOBAL_STATS from user_indexes where index_name=index_name;

如果是YES，则是全局索引
如果是NO，则是本地索引

SELECT INDEX_NAME, STATUS FROM USER_INDEXES WHERE TABLE_NAME = 'INDEX_NAME'

QUOTE:

---

原帖由 wwwxcj 于 2008-7-2 16:39 发表
select GLOBAL_STATS from user_indexes where index_name=index_name;

如果是YES，则是全局索引
如果是NO，则是本地索引

---

For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)

看视图user_part_indexes的locality字段

2，3 楼好像都不对
2楼的错误4楼解了
3楼那个使用来看是否分区，但是没法看是否是全局还是本地

lz应该看索引的和表的ddl来看是否是全局还是本地

SQL> select dbms_metadata.get_ddl('INDEX','BIG_TABLE_P_IND') from dual;

DBMS_METADATA.GET_DDL('INDEX',
--------------------------------------------------------------------------------

  CREATE INDEX "MYDB"."BIG_TABLE_P_IND" ON "MYDB"."BIG_TABLE_P" ("OBJECT_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(
  BUFFER_POOL DEFAULT)LOCAL
(PARTITION "P1"
  PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TEST" ,
PARTITION "P2"
  PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TEST" ,
PARTITION "P3"
  PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TEST" ,
PARTITION "P4"
  PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREE

没有local的就是全局索引

QUOTE:

---

原帖由 ZALBB 于 2008-7-2 16:48 发表
看视图user_part_indexes的locality字段

---

Indicates whether the partitioned index is local (LOCAL) or global (GLOBAL)

QUOTE:

---

原帖由 ZALBB 于 2008-7-2 16:48 发表
看视图user_part_indexes的locality字段

---

这个正解~