Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: indexing VARCHAR2 fields
"Gordon" <gwtwaddell_at_eoriginal.com> wrote in message
news:fTAD6.2$KZ5.197_at_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
>
>
>
No, there is no impact, except for an extra length byte per record
No , why should you? a varchar2 is variable length whether in table or in
index.
Your assumption is correct.
Hth,
Sybrand Bakker, Oracle DBA Received on Thu Apr 19 2001 - 13:42:07 CDT