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

@sayan.orasql.org · 2y ago

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

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