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;
database/oracle/indexes.txt · Last modified: 2017/08/10 10:59 (external edit)