Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Indexes on Oracle8i Release 8.1.7.0.0 - Production

Indexes on Oracle8i Release 8.1.7.0.0 - Production

From: Anthony Millard <Anthony.Millard_at_Ramesys.Com>
Date: Mon, 8 Oct 2001 11:42:29 +0100
Message-ID: <6tfw7.38914$jE3.4415311@news6-win.server.ntlworld.com>


Quick query,
I have noticed that the size of the column field on ALL_IND_COLUMNS and USER_IND_COLUMNS is 4000 charatcers in length, but a column can only be 30 characters.
Does anyone know hwy there is such a bit difference in these 2 columns, surely the 4000 only neds to be 30.
This is apperent on all 8 version databases we have installed.

The reason I looked into this is I am tring to look at a performance issue with 1 of our databases and don't know if this is contributing to the problem.

Regards

    Anthony Millard

SQL> DESC ALL_IND_COLUMNS

 Name                            Null?    Type

------------------------------- -------- ----
INDEX_OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME VARCHAR2(4000) COLUMN_POSITION NOT NULL NUMBER COLUMN_LENGTH NOT NULL NUMBER DESCEND VARCHAR2(4) SQL> desc all_tab_columns Name Null? Type
------------------------------- -------- ----
OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) DATA_TYPE VARCHAR2(106) DATA_TYPE_MOD VARCHAR2(3) DATA_TYPE_OWNER VARCHAR2(30) DATA_LENGTH NOT NULL NUMBER DATA_PRECISION NUMBER DATA_SCALE NUMBER NULLABLE VARCHAR2(1) COLUMN_ID NOT NULL NUMBER DEFAULT_LENGTH NUMBER DATA_DEFAULT LONG NUM_DISTINCT NUMBER LOW_VALUE RAW(32) HIGH_VALUE RAW(32) DENSITY NUMBER NUM_NULLS NUMBER NUM_BUCKETS NUMBER LAST_ANALYZED DATE SAMPLE_SIZE NUMBER CHARACTER_SET_NAME VARCHAR2(44) CHAR_COL_DECL_LENGTH NUMBER GLOBAL_STATS VARCHAR2(3) USER_STATS VARCHAR2(3) AVG_COL_LEN NUMBER

Version Details
Oracle8i Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production Received on Mon Oct 08 2001 - 05:42:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US