Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar2

Re: Varchar2

From: <mpir_at_compuserve.com>
Date: Fri, 19 Jun 1998 18:29:35 GMT
Message-ID: <6meamf$kf$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US