To: eygle
不好意思,还得麻烦您!
我现在有这样一个表,您帮忙看看后面的关于主健索引的定义中他的tablespace 给得是否合适?
是和tables在一个表空间中呢还是另外到其他的表空间,普通的索引,我知到单独放置比较好,但是这样的索引我就不知道了!
-- Create table
create table CUX_PROCESS_PRICES
(
HEADER_IDNUMBER not null,
LINE_IDNUMBER not null,
PROCESS_CODE VARCHAR2(100) not null,
DESCRIPTIONVARCHAR2(100),
PRODUCT_CODE VARCHAR2(50) not null,
PER_PRICENUMBER not null,
EXC_QUANTITY NUMBER,
PRIZENUMBER,
MON_QUANTITY NUMBER,
WAST_PRIZE_QUOTIETYNUMBER,
WAST_PRIZE NUMBER,
WAST_AMERCE_QUOTIETY NUMBER,
WAST_AMERCENUMBER,
INFERIOR_PRIZE_QUOTIETYNUMBER,
INFERIOR_PRIZE NUMBER,
INFERIOR_AMERCE_QUOTIETY NUMBER,
INFERIOR_AMERCENUMBER,
BAKE_QUOTIETYNUMBER,
BAKE_PRIZE NUMBER,
BAKE_AMERCENUMBER,
SWEEP_QUANTITY NUMBER,
SWEEP_AMERCE NUMBER,
WASTE_QUANTITY NUMBER,
WASTE_AMERCE NUMBER,
CUM_AMERCE NUMBER,
SHRINK_WAST_AMERCE NUMBER,
PLUNGE_WAST_AMERCE NUMBER,
WORD_WRONG_AMERCENUMBER,
OVER_QUOTIETYNUMBER,
OVER_PRIZE NUMBER,
OVER_AMERCENUMBER,
ATTRIBUTE1 VARCHAR2(240),
ATTRIBUTE2 VARCHAR2(240),
ATTRIBUTE3 VARCHAR2(240),
ATTRIBUTE4 VARCHAR2(240),
ATTRIBUTE5 VARCHAR2(240),
ATTRIBUTE6 VARCHAR2(240),
ATTRIBUTE7 VARCHAR2(240),
ATTRIBUTE8 VARCHAR2(240),
ATTRIBUTE9 VARCHAR2(240),
ATTRIBUTE10VARCHAR2(240),
ATTRIBUTE11VARCHAR2(240),
ATTRIBUTE12VARCHAR2(240),
ATTRIBUTE13VARCHAR2(240),
ATTRIBUTE14VARCHAR2(240),
ATTRIBUTE15VARCHAR2(240),
CREATED_BY NUMBER not null,
LAST_UPDATED_BYNUMBER not null,
LAST_UPDATE_LOGINNUMBER,
CREATION_DATEDATE not null,
LAST_UPDATE_DATE DATE not null,
REQUEST_ID NUMBER,
PROGRAM_APPLICATION_ID NUMBER,
PROGRAM_ID NUMBER,
PROGRAM_UPDATE_DATEDATE,
STANDARD_PRODVARCHAR2(50),
SHRINK_INFERIOR_AMERCE NUMBER,
NEW_QUOTIETY NUMBER,
STANDARD_FLAGVARCHAR2(1) default 'Y',
PROCESS_ID NUMBER
)
tablespace CUXD
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CUX_PROCESS_PRICES
add primary key (HEADER_ID, PROCESS_CODE, PRODUCT_CODE)
using index
tablespace CUXD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
我其他的索引都放在了cuxx里,那么这里
add primary key (HEADER_ID, PROCESS_CODE, PRODUCT_CODE)
using index
tablespace CUXD这个tablespace是否已应该放到CUXX里,我的TABLE在CUXD中,还有我的存储参数是不是也有问题呢?
实在不好意思,老打扰您!
From: Remen 2005.09.03 22:26
|