Funny fact: did you know that infinity < nan?
dbfiddle.uk/eY2lN_CH
#oracle #sql
Didn't find my old post about that - don't remember where and when I already posted that...

Partition pruning and global indexes: orasql.org/2025/03/17/p...

Fixed the package code for the Dr's domain index a bit: added creating index on rowid for fast delete

Interval Search-P.4
The next part of my Interval Search series: I introduce interval quantization, apply it to my Dynamic Range Segmentation method; answer about composite indexes like (id, beg_date, end_date) and invite you to join a new Telegram group for Oracle performance #oracle #ora_perf

Oracle diagnostic events — Cheat sheet:
orasql.org/2021/05/20/o...
#oracle #performance #troubleshooting #oracle_performance

Partitioning by node (instance_number):
orasql.org/2024/12/12/p...
#oracle #gc #rac