select /*+index(AALUSS IAALUSS2*/ * from aaluss where
c_agencyno = '123'
and c_netname = '456'
and c_cityno = '456'
分析结果
Optimizer goal Choose
SELECT STATEMENT, GOAL = CHOOSE
TABLE ACCESS BY INDEX ROWID GYRX AALUSS
INDEX RANGE SCAN GYRX IAALUSS1
我的数据结构
-- Create table
create table AALUSS
(
C_AGENCYNO CHAR(3),
C_NETNO VARCHAR2(9),
C_NETNAME VARCHAR2(36),
C_CITYNO VARCHAR2(4),
C_NETADDRESS VARCHAR2(200),
C_NETZIPCODE VARCHAR2(9),
C_NETCONTACT VARCHAR2(18),
C_NETPHONE VARCHAR2(36),
C_NETFAXNO VARCHAR2(36),
D_NETREGDATE DATE,
C_NETSTATUS CHAR(1),
C_TANO CHAR(2)
);
-- Create indexes
create index IAALUSS1 on AALUSS (C_NETNAME,C_CITYNO);
create index IAALUSS2 on AALUSS (C_AGENCYNO,C_NETNO,C_NETNAME,C_CITYNO);
