重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-14134: indexes cannot use both DESC [打印本页]

作者: admin    时间: 2016-8-18 10:14
标题: ORA-14134: indexes cannot use both DESC
ORA-14134: indexescannot use both DESC and REVERSE
Cause:
An attempt was made to make a reverse index with someindex columns
marked DESC.
Action: Donot use DESC in reverse indexes. The rule-based optimizer can scan
indexes backwards, which allows a normal reverse index to simulate a reverse
index with columns marked DESC.







欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2