Re: Unique index access path seems very slow
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 25 Jan 2023 08:30:40 -0500
Message-ID: <2a59a1ba-3c62-329b-c9d5-faff119660da_at_gmail.com>
Date: Wed, 25 Jan 2023 08:30:40 -0500
Message-ID: <2a59a1ba-3c62-329b-c9d5-faff119660da_at_gmail.com>
On 1/25/23 03:45, yudhi s wrote:
> Regarding your teams thought of list partition the encrypted table
> column with the last letter. You would end up in 16 list partitions.
> However as your data or say SHA512 value will be distributed across so
> you will end up relying only on luck to eliminate some table/index
> partition scans of your encrypted table, which I think would not be a
> good strategy.
Pap, you should ask yourself one question only: do I feel lucky? Well, do you?
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 25 2023 - 14:30:40 CET