Subject | Re: [firebird-support] Re: Natural Plan when grouping by 5 indexed columns? |
---|---|
Author | Ann W. Harrison |
Post date | 2007-02-02T21:20:08Z |
Richard Wesley wrote:
do a full sweep pass and eliminate unneeded record versions.
Since it doesn't even a read-only database could have inappropriate
record versions in the indexes.
Regards,
Ann
>Basically, aside from not handling the transactions, none.
> Are any optimisations applied when a database is read-only?
>When you make a database read-only, Falcon could, but doesn't
do a full sweep pass and eliminate unneeded record versions.
Since it doesn't even a read-only database could have inappropriate
record versions in the indexes.
Regards,
Ann