Re: Fixing Performance issue with less selective columns
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 25 Aug 2021 23:03:58 -0400
Message-ID: <ad51912d-3520-2f23-d7e7-885f9744b8db_at_gmail.com>
Date: Wed, 25 Aug 2021 23:03:58 -0400
Message-ID: <ad51912d-3520-2f23-d7e7-885f9744b8db_at_gmail.com>
Well, if the database is an OLTP database, I would also consider creating a single table hash cluster. True, that would probably require quite a large reorganization of the table but only the OP can decide whether it's worth the effort or not. After all, such decisions are eventually made on the cost/benefit basis.
On 8/25/21 2:14 PM, Lothar Flatz wrote:
> This scenario cries for bitmap indexes.
> Bitmap Indexes can deal with "not equal" as well as "is null".
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 26 2021 - 05:03:58 CEST