Subject | Re: [Firebird-general] pro&contra |
---|---|
Author | Aage Johansen |
Post date | 2009-08-28T22:28:47Z |
Steve Summers wrote:
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.
> From: Firebird-general@yahoogroups.comEquality searches should be able to use encrypted index, full table
> [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.
>
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.