1.sql
SQL> set linesize 200
SQL> set pagesize 200
SQL> select nvl(max(to_number(mingxibh)), 0) as lMaxXuhao
from klnl_dkkhmx
where dkjiejuh = '20151020000935'
and farendma = '9999'
and trim(translate(mingxibh, '0123456789', ' ')) is null; 2 3 4 5
LMAXXUHAO
----------
2
SQL> select table_name,index_name from user_indexes a where a.table_name=upper('klnl_dkkhmx')
2 ;
TABLE_NAME INDEX_NAME
------------------------------ ------------------------------
KLNL_DKKHMX KLNL_DKKHMX_IDX3
KLNL_DKKHMX KLNL_DKKHMX_IDX1
create unique index KLNL_DKKHMX_IDX1 on KLNL_DKKHMX (MINGXIBH, DKJIEJUH, FARENDMA);
create index KLNL_DKKHMX_IDX3 on KLN
oracle 执行计划改变
最新推荐文章于 2021-04-14 05:56:50 发布
本文详细探讨了Oracle数据库中执行计划的变化,分析了导致执行计划改变的各种因素,包括统计信息更新、索引调整、SQL语句改写等。通过实例解析,揭示了执行计划优化的重要性及其对数据库性能的影响,为DBA提供了优化数据库操作的宝贵见解。
摘要由CSDN通过智能技术生成