From: "Gordon" <gwtwaddell@eoriginal.com>
Newsgroups: comp.databases.oracle.server
Subject: indexing VARCHAR2 fields
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <fTAD6.2$KZ5.197@client>
Date: Thu, 19 Apr 2001 08:30:26 -0400
NNTP-Posting-Host: 38.203.126.253
X-Trace: client 987683403 38.203.126.253 (Thu, 19 Apr 2001 08:30:03 EDT)
NNTP-Posting-Date: Thu, 19 Apr 2001 08:30:03 EDT


If I have a varchar2(4000) column that I'm going to index and 99.9% of the
time
that column will be <50 bytes.  Is there any impact leaving the column at
4096?
Any reason to reduce the column size?  I'm assuming that an index of a
varchar2 column
is still variable length, but I couldn't find that stated anywhere in the
Oracle docs.

I know that there's a restriction that an indexed column must be <=
BLOCK_SIZE.

    TIA - Gordon