Re: Fixing Performance issue with less selective columns

Yes, that is true. I did use them nevertheless, with overestimating the size of data with the same cluster key. I am aware of the space waste caused by this but the situation in which I used them was precisely what you described: I needed to speed up resolution of a single query condition. I didn't care about anything else. That is why I stipulated that only the OP can do cost-benefit analysis. Neither you nor me know exactly how the table is used. We are discussing a single query.

On 8/26/21 6:43 AM, Jonathan Lewis wrote:
> Two major problems with single table hash clusters
>
> a) (Show-stopper) You shouldn't use them for transaction tables
> because you're supposed to know a fixed limiting size for the data
> before you create the cluster

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l