IOT:
索引组织表:
create table iot_address(a varchar2(100) reference emp(a) on delete cascade,b varchar2(100)
primary key (a))
organization index
/
1>on delete cascade;
2>on delete set null;
索引组织表使用以下情况:
1>只访问主键的情况.也就是仅仅访问索引列.
2>只通过主键来进行访问,例如:代码找名字 .
cluster TABLE and cluster index:
create cluster emp_dept_cluster(deptno number(2))
size 1024
create index emp_dept_cluster_idx on cluster emp_dept_cluster
create table dept(deptno number(2) primary key,dname varchar(14),loc varchar2(13))
cluster emp_dept_cluster(deptno)
create table emp(empo number primary key,deptno number(2) reference dept(dept_no))
cluster emp_dept_cluster(deptno)