| Subject | Re: count records of all tables |
|---|---|
| Author | emb_blaster |
| Post date | 2009-12-09T14:23:37Z |
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
I've found this tip very usefull too. But, it is a good pratice do an update in system tables do update all indexes? or is better one by one even if I want do this to all? (sorry if it is in old msgs but I having some issues with the search =o[ )
/* first update the statistics */
UPDATE RDB$INDICES SET RDB$STATISTICS = -1;
>Hi!!
> I quite like Ivan Prenosils solution for approximate counts of tables with primary keys (at least if some of the tables are huge):
>
> www.firebirdfaq.org/faq5/
>
> Set
I've found this tip very usefull too. But, it is a good pratice do an update in system tables do update all indexes? or is better one by one even if I want do this to all? (sorry if it is in old msgs but I having some issues with the search =o[ )
/* first update the statistics */
UPDATE RDB$INDICES SET RDB$STATISTICS = -1;