我看了一下，这个表很简单的表，怎么不走索引呢，难道没有索引，
于是我远程看了一下
SQL> r
1* select INDEX_OWNER,INDEX_NAME,COLUMN_NAME,COLUMN_POSITION,table_name from dba_ind_columns where table_name='YS_ZY_JBZD' order by 2,4
INDEX_OWNER INDEX_NAME COLUMN_NAME COLUMN_POSITION TABLE_NAME
------------------------------ ------------------------------ ------------------------------ --------------- ------------------------------
HIS IDX_YS_ZY_JBZD_JBDM JBDM 1 YS_ZY_JBZD
HIS IDX_YS_ZY_JBZD_JZHM JZHM 1 YS_ZY_JBZD
HIS PK_YS_ZY_JBZD JLBH 1 YS_ZY_JBZD
HIS PK_YS_ZY_JBZD1 JLBH 1 YS_ZY_JBZD
HIS PK_YS_ZY_JBZD1 JBDM 2 YS_ZY_JBZD
再次验证，看看计划情况
SQL> explain plan
2 for
3 select * from his.YS_ZY_JBZD where JLBH=929;
Explained.
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 913959468
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2025-4-17 08:47:45
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对