Oracle 12.2 is Released!

Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right!

Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

I’m downloading it as I write, and hopefully will have time to play with it a little bit soon. I wrote so much about new features that I have to try some of them at least. Stay tuned!

Scanning an Index

The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about. In this post I’d like to talk about a specific use case that I’ve seen a few times, and is related to index scans and performance.

Continue reading