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: 2019/10/31 09:04
  • by 127.0.0.1