21/8/3 4 / 50
Oracle 索引回顾
创建主键
创建主键
在创建表时创建主键
在创建表时创建主键
关键是主键也占空间，要指定表空间：
关键是主键也占空间，要指定表空间：
CREATE TABLE insured_autos
CREATE TABLE insured_autos
(policy_id NUMBER,
(policy_id NUMBER,
vin VARCHAR2(40),
vin VARCHAR2(40),
coverage_begin DATE,
coverage_begin DATE,
coverage_term NUMBER,
coverage_term NUMBER,
CONSTRAINT pk_insured_autos PRIMARY KEY (policy_id,vin)
CONSTRAINT pk_insured_autos PRIMARY KEY (policy_id,vin)
USING INDEX TABLESPACE index
USING INDEX TABLESPACE index
STORAGE (INITIAL 10M NEXT 2M PCTINCREASE 0)
STORAGE (INITIAL 10M NEXT 2M PCTINCREASE 0)
);
);
