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-l
Received on Thu Aug 26 2021 - 05:03:58 CEST