April 1999
Intermediate to advanced
584 pages
23h 17m
English
The following example creates an index on the empno and ename columns of scott’s emp table, with the indicated storage parameters:
CREATE INDEX emp_ndx ON scott.emp(empno,ename) STORAGE (INITIAL 50K NEXT 10K PCTINCREASE 0 MAXEXTENTS 10) TABLESPACE users PCTFREE 20
Read now
Unlock full access