联合主键自动创建索引，建表时也可指定索引

[code]C:\\Documents and Settings\\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 20 11:05:43 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN

SQL> conn awen/oracle
已连接。

SQL> select object_name from all_objects where object_type='INDEX' and owner='A
WEN';

OBJECT_NAME
------------------------------
SYS_C005556
SYS_C005558
OB_INDEX

SQL> create table index_text ( id integer,name varchar2(10), tel varchar2(11)
,constraint in_pk primary key (id,name));

表已创建。

SQL> select object_name from all_objects where object_type='INDEX' and owner='A
WEN';

OBJECT_NAME
------------------------------
SYS_C005556
IN_PK
SYS_C005558
OB_INDEX

SQL> drop table index_text;

表已删除。

SQL> create table index_text ( id integer,name varchar2(10), tel varchar2(11)
,constraint in_pk primary key (id,name) using index(create index ind_in on index
_text(id,name)));

表已创建。

SQL> select object_name from all_objects where object_type='INDEX' and owner='A
WEN';

OBJECT_NAME
------------------------------
SYS_C005556
BIN$+/SyV4M+T7idIAxFzHOYHw==$0
IND_IN
SYS_C005558
OB_INDEX

SQL> drop table index_text;

表已删除。

SQL> select object_name from all_objects where object_type='INDEX' and owner='A
WEN';

OBJECT_NAME
------------------------------
SYS_C005556
BIN$0cjdZ5wsQUOFxz2NjVawew==$0
BIN$+/SyV4M+T7idIAxFzHOYHw==$0
SYS_C005558
OB_INDEX

SQL>[/code]