Re: Limit on number of columns in an index
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-lReceived on Tue Mar 25 2008 - 09:28:54 CDT