在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)
- DCREATE INDEX my_idx_1 ON employee(salary)REVERSE