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".
