Hi Andre,

> Dear Arno,
> here are the results:
> orig_db:
> RDB$INDEX_NAME RDB$STATISTICS
> ================================ ==============
> RDB$FOREIGN109 0,00233644852414727
> RDB$PRIMARY49 3,32189483742695E-6
> RDB$FOREIGN122 0,0333333350718021
> RDB$PRIMARY31 2,96226080536144E-5
> RDB$PRIMARY22 0,00380228133872151
>
> backuped_db:
> RDB$INDEX_NAME RDB$STATISTICS
> ================================ ==============
> RDB$FOREIGN109 0
> RDB$PRIMARY49 0
> RDB$PRIMARY31 0
> RDB$PRIMARY22 0
> RDB$FOREIGN122 0,333333343267441

Interesting why the most are zero after restore, but thats wrong.

Run :

SET STATISTICS INDEX RDB$FOREIGN109;
SET STATISTICS INDEX RDB$PRIMARY49;
SET STATISTICS INDEX RDB$PRIMARY31
SET STATISTICS INDEX RDB$PRIMARY22
SET STATISTICS INDEX RDB$FOREIGN122;

and probably you need to run SET STATISTICS for every index.
Let know the results after running SET STATISTICS.
You could write a SP that runs SET STATISTICS with EXECUTE VARCHAR for every
index.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info