indexing VARCHAR2 fields

From: Gordon <gwtwaddell_at_eoriginal.com>
Date: Thu, 19 Apr 2001 08:30:26 -0400
Message-ID: <fTAD6.2$KZ5.197@client>

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 Received on Thu Apr 19 2001 - 07:30:26 CDT