Subject Re: [firebird-support] Re: Natural Plan when grouping by 5 indexed columns?
Author Ann W. Harrison
Richard Wesley wrote:
> Are any optimisations applied when a database is read-only?

Basically, aside from not handling the transactions, none.

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.