在Oracle中,你需要创立索引提高薪水审查旳性能,该审查要对员工薪水提高12个百分点后进行分析解决,下面哪个create index命令能解决此问题(选一项) A. CREATE INDEX my_idx_1 ON employee(salary*1.12); B. CREATE UNIQUE INDEX my_idx_1 ON employee(salary) C. CREATE BITMAP INDEX my_idx_1 ON employee(...
Create table test_uid(name varchar2(10), constraint TEST_UID_PK PRIMARY KEY(NAME) USING INDEX (Create unique index uid_test_uid on test_uid(name) tablespace TABLESPACE2); ) 当然,也可以分部来处理. create table testone(name varchar2(10 char)) TABLESPACE1; ALTER TABLE TESTONE ADD CONSTRAINT ...
( sequence_options ) ] | UNIQUE index_parameters | PRIMARY KEY index_parameters | REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED...
在Oracle中,你需要创建索引提高薪水审查的性能,该审查要对员工薪水提高12个百分点后进行分析处理,下面哪个createindex命令能解决此问题()。 ACREATE INDEX my_idx_1 ON employee(salary*1.12) BCREATE UNIQUE INDEX my_idx_1 ON employee(salary) CCREATE BITMAP INDEX my_idx_1 ON employee(salary)...
( sequence_options ) ] | UNIQUE index_parameters | PRIMARY KEY index_parameters | REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED...