Subject Re: [Firebird-general] pro&contra
Author Aage Johansen
Steve Summers wrote:
> From: Firebird-general@yahoogroups.com
> [mailto:Firebird-general@yahoogroups.com] On Behalf Of Aage Johansen
>
>> I expect performance to be lousy for some/many kinds of queries as indexes
> will be less useful.
>
> I suspect they must keep the index values unencrypted, or just do page level
> encryption on the index pages. They couldn't index the encrypted values
> without screwing up everything else.
>

Equality searches should be able to use encrypted index, full table
scans will be necessary for ranges.
Even equality searches may require table scans if you need to pad
short fields to improve on quality of encryption.


--
Aage J.