10月
27
2010
今天又遇到了个问题,我在应用中发现我们的一个web列表显示的特别慢,列表只是简单的将数据单表数据order 下输出,并且是对
Sql代码
create table T_ATTACKEVENT
(
ATTEVNT_ID_N NUMBER not null,
ATTEVNT_SIP_C VARCHAR2(15) not null,
ATTEVNT_SPORT_N NUMBER not null,
ATTEVNT_DIP_C VARCHAR2(15) not null,
ATTEVNT_DPORT_N NUMBER not null,
ATTEVNT_PROTOCOL_C VARCHAR2(10),
ATTEVNT_TIME_C TIMESTAMP(6) not null,
ATTEVNT_NOOFDAY_N NUMBER not null
)
alter table T_ATTACKEVENT
add constraint PK_ATTACKEVENT primary key (ATTEVNT_ID_N)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(