compressed index and partition table?

From: Kate Lin <linlin27_at_sympatico.ca>
Date: Thu, 30 Aug 2001 23:33:28 -0400
Message-ID: <zqDj7.39550$Hr2.3661961@news20.bellglobal.com>

I just migrate database form oracle 7.3 to Oracle 8.1.6

these is a large table:

ARCH_RTU_DATA(
  A_RTUD_TAG_NAME VARCHAR2(24) NOT NULL,
  A_RTUD_TRUE_DATE DATE NOT NULL,

.....
)

one composed primary key:
ALTER TABLE ARCH_RTU_DATA ADD CONSTRAINT ARCH_RTU_DATA_PK PRIMARY KEY (A_RTUD_TAG_NAME,A_RTUD_TRUE_DATE) USING INDEX ....; another index:

CREATE INDEX ARCH_RTU_DATA_TRUE_DATE_IDX ON ARCH_RTU_DATA (A_RTUD_TRUE_DATE) ... Two questions:

if i change the composed primary key to comressed index, can i get better performance besides the less space?

create unique index arch_rtu_data_pk on
arch_rtu_data(a_rtud_tag_name, a_rtud_true_date) compress 1

2. which field should be selected as a partition key if we want to use partition table?

thanks a lot. Received on Thu Aug 30 2001 - 22:33:28 CDT