Eureka Moment Wiki

One eureka moment at the time

User Tools

Site Tools


database:oracle:indexes

Manually create indexes

CREATE UNIQUE INDEX ix_inv_manufacturers_id ON "inv_manufacturers"("id") TABLESPACE INV_IDX;
CREATE UNIQUE INDEX ix_inv_persons_id ON "inv_persons"("id") TABLESPACE INV_IDX;
CREATE UNIQUE INDEX ix_inv_racks_id ON "inv_racks"("id") TABLESPACE INV_IDX;
CREATE UNIQUE INDEX ix_inv_rooms_id ON "inv_rooms"("id") TABLESPACE INV_IDX;
CREATE UNIQUE INDEX ix_inv_devices_iid ON "inv_devices"("iid") TABLESPACE INV_IDX;

Discussion

Enter your comment:
T B V M C
 
database/oracle/indexes.txt · Last modified: 2019/10/31 09:04 (external edit)