database:oracle:indexes

Differences

This shows you the differences between two versions of the page.


—database:oracle:indexes [2019/10/31 09:04] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== Manually create indexes ====== 
 +<code sql>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;</code> 
 +{{tag>[satabase db oracle index]}}