Indexes
|
| < Day Day Up > |
|
There are four indexes in the ORA_EMP database:
-- type: normal CREATE INDEX ind_acct_id ON accounts ( acct_id ) STORAGE ( MAXEXTENTS UNLIMITED BUFFER_POOL KEEP) TABLESPACE user_ind_tbs; CREATE INDEX ind_dept_name ON departments ( dept_name ) TABLESPACE user_ind_tbs; CREATE INDEX ind_emp_name ON employees ( last_name ) TABLESPACE user_ind_tbs; CREATE INDEX ind_log_code ON log_table ( code ) TABLESPACE user_ind_tbs; CREATE INDEX ind_office_bld ON offices ( building ) TABLESPACE user_ind_tbs REVERSE; -- table: debug_table -- type: bitmap index CREATE BITMAP INDEX bm_ind_debug_str ON debug_table (debug_str) TABLESPACE user_ind_tbs; -- table: accounts -- type: function based index CREATE INDEX fb_ind_account_rate ON accounts (current_employees / max_employees) TABLESPACE user_ind_tbs;
|
| < Day Day Up > |
|
