12. Using the Query Optimizer : Specialized Statistics Processing : Statistics in Text Files : Sample Text File Statistics
 
Share this page                  
Sample Text File Statistics
A sample output file generated using the Direct Output to Server File option of the Display Statistics dialog is shown below. This same text file can be used as input to the optimization process, as described in the next section, Loading Optimizer Statistics from a Text File:
*** statistics for database demodb version: 00850
*** table brel rows:151 pages:3 overflow pages:1
*** column col1 of type integer (length:4, scale:0, nullable)
date:2000_02_24 16:04:37 GMT unique values:132.000
repetition factor:1.144 unique flag:N complete flag:0
domain:0 histogram cells:16 null count:0.0000000       value length:4
cell:   0    count:0.0000000    repf:0.0000000    value:      0
cell:   1    count:0.0728477    repf:1.3750000    value:     23
cell:   2    count:0.0728477    repf:1.8333334    value:     31
cell:   3    count:0.0728477    repf:1.3750000    value:     59
cell:   4    count:0.0728477    repf:1.1000000    value:    138
cell:   5    count:0.0728477    repf:1.0000000    value:    151
cell:   6    count:0.0728477    repf:1.0000000    value:    162
cell:   7    count:0.0728477    repf:1.0000000    value:    173
cell:   8    count:0.0662252    repf:1.2500000    value:    181
cell:   9    count:0.0662252    repf:1.1111112    value:    193
cell:  10    count:0.0662252    repf:1.2500000    value:    202
cell:  11    count:0.0662252    repf:1.0000000    value:    214
cell:  12    count:0.0662252    repf:1.0000000    value:    224
cell:  13    count:0.0662252    repf:1.0000000    value:    236
cell:  14    count:0.0662252    repf:1.2500000    value:    256
cell:  15    count:0.0264901    repf:1.0000000    value:    261