Yes, it's a joke. As bitmap indexes stores NULL values (instead of B+
indexes, which don't) they not suffer this bug.
Em ter., 26 de mai. de 2020 às 09:25, Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
escreveu:
On 26/05/2020 12:40, Luis Claudio Dias dos Santos wrote:
Use bitmap indexes! :-)
No, please don't! At least, not in an OLTP or frequently updated system.
Deadlocks will occur! (Ask me how I know!)
(I did notice the smiley by the way Luis, but some may not have.)
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767