Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: indexing VARCHAR2 fields
The recordsize must be <= db_block_size/3. So you *must* have a db with db_block_size = 16384 at least.
Martin
Gordon wrote:
>
> 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 - 15:27:35 CDT