17,377
社区成员
发帖
与我相关
我的任务
分享
select *
from smt_scan_half
where rec_datetime>='20090820160000' and rec_datetime<='20090820195959' and pn_no='50-01647-00J' and line_no='N02'code]
而用
[code=SQL]select *
from smt_scan_half
where rec_datetime>='20090820160000' and rec_datetime<='20090820195959' and pn_no='50-01647-00J' code]
只需要4毫秒.
請哪位高人指點一下為什麽?
下面是我的索引的結構
[code=SQL]CREATE INDEX INDEX_SMT_SCAN_HALF5 ON SMT_SCAN_HALF
(REC_DATETIME)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 224384K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX INDEX_SMT_SCAN_HALF6 ON SMT_SCAN_HALF
(LINE_NO, PN_NO)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 671616K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE UNIQUE INDEX P_SMT_SCAN_HALF ON SMT_SCAN_HALF
(BAR_NO)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 554752K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX INDEX_SMT_SCAN_HALF1 ON SMT_SCAN_HALF
(LINE_NO, PRO_DATE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 352896K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX INDEX_SMT_SCAN_HALF2 ON SMT_SCAN_HALF
(PRO_DATE)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 295552K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX INDEX_SMT_SCAN_HALF3 ON SMT_SCAN_HALF
(SFC_NO)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 313088K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;