According to Oracle, dba_tables.num_rows with decimals
do not have any impact on the optimiser, access plan
will be the same.
They will open a bug on this.
- paquette stephane <stephane_paquette_at_yahoo.com> a
écrit : > dba_tables.num_rows is showing with decimals
!
> This is on 8.1.5.1/Solaris 2.6 .
>
> MOT.WORLD:idba>select table_name,num_rows from
> dba_tables where num_rows <> trunc(num_rows);
>
> TABLE_NAME NUM_ROWS
> ------------------------------ ---------
> VGN_HISTORY 10564.646
> VGN_PR 78.787879
> VGN_TK 546.46465
> VGN_UR 944.44444
> MOH_NOEUD_EXEMPLES 5180.8081
> MOH_OPEMKT_CADEAU 204.0404
> MOH_OPEMKT_ELEMENT 17.171717
> MOH_PARAMETRE 201.0101
> MOH_REDIRECTION 68.686869
> AGENDA 14.141414
> NEXT_ID 12.121212
> TEMPLATE 661.61616
> TEMPLATE_PATH 614.14141
> VGN_CI 895.9596
> MOH_TMP_NOEUD_EXEMPLES 5361.6162
> MOH_TRANSAC_PAIEMENT 62388.889
> MOH_ARTICLES_ASSOCIES 15.151515
> MOH_IMPORT 93847.475
> MOH_ORIGINE 56.565657
> MOH_STAT_HISTO_STOCK 2046383.8
> MOH_STAT_RESULTAT 2629.2929
> MOH_STAT_TBORD 390.90909
> DR$TEMPLATE_CTX1$I 780169.7
> MOH_ARTICLE_AVIS 72.727273
> MOH_STAT_RESULTAT_BTQ 654.54545
> MOH_STAT_TBORD_BTQ 120.20202
> MOH_STAT_GRP_FAM_CORA 22392.929
> MOH_BANDEAU 20.20202
>
> 28 rows selected.
>
>
>
> Pretty strange , anybody ?
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Fri Aug 04 2000 - 10:23:37 CDT
