Subject | Re: [firebird-support] Problem |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-08-21T08:16:41Z |
> 4. export scheme and indexes from the original databaseI'd gamble on different index statistics. Backup-restore or SET
> 5. import scheme and indexes into my new database
> 6. copy all data from tables (not system-tables) of the original database into the new database
>
> Maybe the problem is caused by the content of system tables I did not copy into the new database?
STATISTICS should help.
You could compare query plans in both databases...
SY, SD.