Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar2
If you analyze the tables and indexes, you will get the size and row count
figures in sys.dba_tables and sys.dba_indexes.
If you do, though, be careful about your optimizer setting. If it is 'CHOOSE' (the default) you could change the way your SQL behaves. (If the setting is 'RULE' or 'COST', you will be ok.)
In article <01bd9ac0$c52645a0$d35a0645_at_iguana>,
"Robert K. Tucker" <rat_at_nospam.epnet.com> wrote:
>
> Is there an easy way to get the average column length of a Varchar2
field?
> This is for re-sizing guestimates of indexed columns.Thanx
> -rkt
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 13:29:35 CDT