About index range scans, disk re-reads and how your new car can go 600 miles per hour! | Tanel Poder Consulting

[utterances-bot]

About index range scans, disk re-reads and how your new car can go 600 miles per hour! | Tanel Poder Consulting

Despite the title, this is actually a technical post about Oracle, disk I/O and Exadata & Oracle In-Memory Database Option performance. Read on :)
If a car dealer tells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically different from all the old ones. You don’t just get orders of magnitude performance improvements by making small changes.
Perhaps the car bends space around it instead of moving – or perhaps it has a jet engine built on it (like the one below :-) :

• Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/2014/09/17/about-index-range-scans-disk-re-reads-and-how-your-new-car-can-go-600-miles-per-hour/