如何提高oracle 数据库查询效率.docxVIP

Oracle查询指定索引提高查询效率一个1600万数据表一个1600万数据表－－短信上行表TBL_SMS_MO结构：CREATE TABLE TBL_SMS_MO(SMS_ID NUMBER,MO_ID VARCHAR2(50),MOBILE VARCHAR2(11),SPNUMBER VARCHAR2(20),MESSAGE VARCHAR2(150),TRADE_CODE VARCHAR2(20),LINK_ID VARCHAR2(50),GATEWAY_ID NUMBER,GATEWAY_PORT NUMBER,MO_TIME DATE DEFAULT SYSDATE);CREATE INDEX IDX_MO_DATE ON TBL_SMS_MO (MO_TIME)PCTFREE 10INITRANS 2MAXTRANS 255STORAGE( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);CREATE INDEX IDX_MO_MOBILE ON TBL_SMS_MO (MOBILE)PCTFREE 10INITRANS 2MAXTRANS 255STORAGE( INITIAL 64K NEXT 1M MINEXTENTS 1 M