Subject Re: [firebird-support] Index problem that need to be drop and recreated
Author Alexandre Benson Smith
gwc8182 wrote:
> Dear All,
> My question is what could have happened that required
> dropping and recreating the database? I would suspect
> the index is somehow corrupted, if that the case, any
> way I could also check for that since gbak didn't pick
> it up ?
> If the index not optimised correctly, doesn't the gbak
> restore create back the index correctly ?
> Could it be the firebird version being a bit too old?
> Though am planning to move to Firebird 2.0.1
> A year or two ago, I did encounter the same problem
> before from a different customer with different
> computer setup, but the firebird version was the same.
> Just Wondering.......
> John

Perhaps the indices statistics are out of date.

Every time you found a difference in speed between the same statement on
two databases, the first think to look are the used plans on each case.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil