Ok, but how do I restore the statistics? Using "update" statements?
Thanks in advance for your help.
On Saturday, May 12, 2018, 1:19:10 AM CDT, liviuslivius
liviusliv...@poczta.onet.pl [firebird-support]
<firebird-support@yahoogroups.com> wrote:
Hi,
to "backup" statistics you can run query on rdb$indices and rdb$index_segment
tables. And save result to the file.
About table statistics - here is really fine concept that you do not need to
recalculate anything. Table pages count and record size is taken in calc. In
fb3 also record compression level.
Regards,Karol Bieniaszewski #yiv0641671250 #yiv0641671250 --
#yiv0641671250ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv0641671250 #yiv0641671250ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv0641671250 #yiv0641671250ygrp-mkp #yiv0641671250hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0641671250 #yiv0641671250ygrp-mkp #yiv0641671250ads
{margin-bottom:10px;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad
{padding:0 0;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad p
{margin:0;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad a
{color:#0000ff;text-decoration:none;}#yiv0641671250 #yiv0641671250ygrp-sponsor
#yiv0641671250ygrp-lc {font-family:Arial;}#yiv0641671250
#yiv0641671250ygrp-sponsor #yiv0641671250ygrp-lc #yiv0641671250hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0641671250
#yiv0641671250ygrp-sponsor #yiv0641671250ygrp-lc .yiv0641671250ad
{margin-bottom:10px;padding:0 0;}#yiv0641671250 #yiv0641671250actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0641671250
#yiv0641671250activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0641671250
#yiv0641671250activity span {font-weight:700;}#yiv0641671250
#yiv0641671250activity span:first-child
{text-transform:uppercase;}#yiv0641671250 #yiv0641671250activity span a
{color:#5085b6;text-decoration:none;}#yiv0641671250 #yiv0641671250activity span
span {color:#ff7900;}#yiv0641671250 #yiv0641671250activity span
.yiv0641671250underline {text-decoration:underline;}#yiv0641671250
.yiv0641671250attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0641671250 .yiv0641671250attach div a
{text-decoration:none;}#yiv0641671250 .yiv0641671250attach img
{border:none;padding-right:5px;}#yiv0641671250 .yiv0641671250attach label
{display:block;margin-bottom:5px;}#yiv0641671250 .yiv0641671250attach label a
{text-decoration:none;}#yiv0641671250 blockquote {margin:0 0 0
4px;}#yiv0641671250 .yiv0641671250bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0641671250
.yiv0641671250bold a {text-decoration:none;}#yiv0641671250 dd.yiv0641671250last
p a {font-family:Verdana;font-weight:700;}#yiv0641671250 dd.yiv0641671250last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0641671250
dd.yiv0641671250last p span.yiv0641671250yshortcuts
{margin-right:0;}#yiv0641671250 div.yiv0641671250attach-table div div a
{text-decoration:none;}#yiv0641671250 div.yiv0641671250attach-table
{width:400px;}#yiv0641671250 div.yiv0641671250file-title a, #yiv0641671250
div.yiv0641671250file-title a:active, #yiv0641671250
div.yiv0641671250file-title a:hover, #yiv0641671250 div.yiv0641671250file-title
a:visited {text-decoration:none;}#yiv0641671250 div.yiv0641671250photo-title a,
#yiv0641671250 div.yiv0641671250photo-title a:active, #yiv0641671250
div.yiv0641671250photo-title a:hover, #yiv0641671250
div.yiv0641671250photo-title a:visited {text-decoration:none;}#yiv0641671250
div#yiv0641671250ygrp-mlmsg #yiv0641671250ygrp-msg p a
span.yiv0641671250yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0641671250
.yiv0641671250green {color:#628c2a;}#yiv0641671250 .yiv0641671250MsoNormal
{margin:0 0 0 0;}#yiv0641671250 o {font-size:0;}#yiv0641671250
#yiv0641671250photos div {float:left;width:72px;}#yiv0641671250
#yiv0641671250photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0641671250
#yiv0641671250photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0641671250
#yiv0641671250reco-category {font-size:77%;}#yiv0641671250
#yiv0641671250reco-desc {font-size:77%;}#yiv0641671250 .yiv0641671250replbq
{margin:4px;}#yiv0641671250 #yiv0641671250ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0641671250 #yiv0641671250ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0641671250
#yiv0641671250ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0641671250
#yiv0641671250ygrp-mlmsg select, #yiv0641671250 input, #yiv0641671250 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0641671250
#yiv0641671250ygrp-mlmsg pre, #yiv0641671250 code {font:115%
monospace;}#yiv0641671250 #yiv0641671250ygrp-mlmsg *
{line-height:1.22em;}#yiv0641671250 #yiv0641671250ygrp-mlmsg #yiv0641671250logo
{padding-bottom:10px;}#yiv0641671250 #yiv0641671250ygrp-msg p a
{font-family:Verdana;}#yiv0641671250 #yiv0641671250ygrp-msg
p#yiv0641671250attach-count span {color:#1E66AE;font-weight:700;}#yiv0641671250
#yiv0641671250ygrp-reco #yiv0641671250reco-head
{color:#ff7900;font-weight:700;}#yiv0641671250 #yiv0641671250ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0641671250 #yiv0641671250ygrp-sponsor
#yiv0641671250ov li a {font-size:130%;text-decoration:none;}#yiv0641671250
#yiv0641671250ygrp-sponsor #yiv0641671250ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0641671250
#yiv0641671250ygrp-sponsor #yiv0641671250ov ul {margin:0;padding:0 0 0
8px;}#yiv0641671250 #yiv0641671250ygrp-text
{font-family:Georgia;}#yiv0641671250 #yiv0641671250ygrp-text p {margin:0 0 1em
0;}#yiv0641671250 #yiv0641671250ygrp-text tt {font-size:120%;}#yiv0641671250
#yiv0641671250ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0641671250
