我现在有表结构;
create table TBBOOKDATA
(
ITEMID NUMBER not null,
URL VARCHAR2(300),
ITEMNAME VARCHAR2(100),
AUTHOR VARCHAR2(100),
ISBN VARCHAR2(20),
PUBLISHER VARCHAR2(100),
ABSTRACT VARCHAR2(4000),
IMAGE_URL VARCHAR2(300),
ADDTS DATE,
PRICE VARCHAR2(100),
ABSTRACT2 VARCHAR2(4000),
UPDATETS DATE,
CAN_BUY VARCHAR2(8) default 'y',
CAN_READ VARCHAR2(8) default 'y',
REAL_PRICE VARCHAR2(100),
PUBLICATION_DATE VARCHAR2(100),
ITEM_TYPE VARCHAR2(8),
ITEM_QUALITY NUMBER,
CATEGORY VARCHAR2(100),
AUDITRESULT NUMBER default -1,
AUDITVIEW VARCHAR2(500)
)
请问,怎么在这个表上创建以URL 为键的索引,谢谢,在线等
create table TBBOOKDATA
(
ITEMID NUMBER not null,
URL VARCHAR2(300),
ITEMNAME VARCHAR2(100),
AUTHOR VARCHAR2(100),
ISBN VARCHAR2(20),
PUBLISHER VARCHAR2(100),
ABSTRACT VARCHAR2(4000),
IMAGE_URL VARCHAR2(300),
ADDTS DATE,
PRICE VARCHAR2(100),
ABSTRACT2 VARCHAR2(4000),
UPDATETS DATE,
CAN_BUY VARCHAR2(8) default 'y',
CAN_READ VARCHAR2(8) default 'y',
REAL_PRICE VARCHAR2(100),
PUBLICATION_DATE VARCHAR2(100),
ITEM_TYPE VARCHAR2(8),
ITEM_QUALITY NUMBER,
CATEGORY VARCHAR2(100),
AUDITRESULT NUMBER default -1,
AUDITVIEW VARCHAR2(500)
)
请问,怎么在这个表上创建以URL 为键的索引,谢谢,在线等
一般不会安URL进行查询
1、创建唯一索引
create unique index index_name on table_name(id); 2、创建单列索引
create index i_name on tb_name(name);--建立表tb_name中name字段索引 3、创建复合索引
create index i_deptno_job on emp(deptno, job); --由表emp的deptno和job字段建立的复合索引 4、重建索引
alter index index_name rebuild;
5、删除索引
drop index index_name;