Re: Limit on number of columns in an index

From: Ram Raman <veeeraman_at_gmail.com>
Date: Tue, 25 Mar 2008 09:28:54 -0500
Message-ID: <effc058d0803250728t3ff18ae2r908da0ca032bfeaa@mail.gmail.com>


Here. But it does not matter. This is run from Peoplesoft. I think it runs in several sessions that the temp table data is not visible to subsequent sessions and hence we are not getting the results. The process is still slow anyway :

CREATE GLOBAL TEMPORARY TABLE PS_DEPR_RP4_TMP (
"ASSET_ID" VARCHAR2(12 byte) NOT NULL,
"PROCESS_INSTANCE" NUMBER(10) NOT NULL,
"BUSINESS_UNIT" VARCHAR2(5 byte) NOT NULL,
"BOOK" VARCHAR2(10 byte) NOT NULL,
"CF_SEQNO" NUMBER NOT NULL,
"FISCAL_YEAR" NUMBER NOT NULL,
"ACCOUNTING_PERIOD" NUMBER NOT NULL,
"TRANS_TYPE" VARCHAR2(3 byte) NOT NULL,
"TRANS_DT" DATE, "DTTM_STAMP" DATE,
"PROJECT_ID" VARCHAR2(15 byte) NOT NULL,
"DEPTID" VARCHAR2(10 byte) NOT NULL,
"CATEGORY" VARCHAR2(5 byte) NOT NULL,
"COST_TYPE" VARCHAR2(1 byte) NOT NULL,
"OPERATING_UNIT" VARCHAR2(8 byte) NOT NULL,
"PRODUCT" VARCHAR2(6 byte) NOT NULL,
"FUND_CODE" VARCHAR2(5 byte) NOT NULL,
"CLASS_FLD" VARCHAR2(5 byte) NOT NULL,
"PROGRAM_CODE" VARCHAR2(5 byte) NOT NULL,
"BUDGET_REF" VARCHAR2(8 byte) NOT NULL,
"AFFILIATE" VARCHAR2(5 byte) NOT NULL, "AFFILIATE_INTRA1" VARCHAR2(10

    byte) NOT NULL, "AFFILIATE_INTRA2" VARCHAR2(10 byte) NOT NULL,     "CHARTFIELD1" VARCHAR2(10 byte) NOT NULL, "CHARTFIELD2"     VARCHAR2(10 byte) NOT NULL, "CHARTFIELD3" VARCHAR2(10 byte)     NOT NULL, "ACTIVITY_SW" NUMBER NOT NULL, "RETIRE_SW" NUMBER     NOT NULL, "DEPR" NUMBER(26, 3) NOT NULL, "DEPR_YTD" NUMBER(26,     3) NOT NULL, "DEPR_LTD" NUMBER(26, 3) NOT NULL, "CURRENCY_CD"     VARCHAR2(3 byte) NOT NULL, "MANUAL_DEPR_TYPE" VARCHAR2(1     byte) NOT NULL, "SPEC_DEPR" NUMBER(26, 3) NOT NULL,     "INITIAL_DEPR" NUMBER(26, 3) NOT NULL, "ACCEL_DEPR" NUMBER(26,     3) NOT NULL, "INCREASE_DEPR" NUMBER(26, 3) NOT NULL,     "STANDARD_DEPR" NUMBER(26, 3) NOT NULL, "COST" NUMBER(26, 3)     NOT NULL, "SALVAGE_VALUE" NUMBER(26, 3) NOT NULL, "GRP_COST"     NUMBER(26, 3) NOT NULL, "GRP_SALVAGE_VALUE" NUMBER(26, 3) NOT     NULL, "DEPR_PDP" NUMBER(26, 3) NOT NULL, "ACCUM_DEPR_ADD"     NUMBER(26, 3) NOT NULL, "ACCUM_DEPR_TRF" NUMBER(26, 3) NOT     NULL, "ACCUM_DEPR_RCT" NUMBER(26, 3) NOT NULL,     "ACCUM_DEPR_RET" NUMBER(26, 3) NOT NULL, "ACCUM_DEPR_REI"     NUMBER(26, 3) NOT NULL, "COST_ADD" NUMBER(26, 3) NOT NULL,     "COST_ADJ" NUMBER(26, 3) NOT NULL, "COST_TRF" NUMBER(26, 3)     NOT NULL, "COST_RCT" NUMBER(26, 3) NOT NULL, "COST_RET"     NUMBER(26, 3) NOT NULL, "COST_REI" NUMBER(26, 3) NOT NULL,     "ACCOUNT_AD" VARCHAR2(10 byte) NOT NULL, "ACCOUNT_FA"     VARCHAR2(10 byte) NOT NULL, "LOCATION" VARCHAR2(10 byte) NOT     NULL, "PROFILE_ID" VARCHAR2(10 byte) NOT NULL,     "GROUP_ASSET_FLAG" VARCHAR2(1 byte) NOT NULL, "TRANS_CODE"     VARCHAR2(5 byte) NOT NULL)

>
>
> On Mon, Mar 24, 2008 at 5:49 AM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> >
> >    To test performance, I defined few global temporary tables with
> > indexes in the process which was using temp tables.
> >
>
> Post your DDL
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 25 2008 - 09:28:54 CDT

Original text of this message