Eureka Moment Wiki

One eureka moment at the time

User Tools

Site Tools


database:oracle:indexes

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database:oracle:indexes [2016/12/19 15:24]
tplecko
database:oracle:indexes [2019/10/31 09:04] (current)
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]}}
database/oracle/indexes.txt · Last modified: 2019/10/31 09:04 (external edit)