I ran into this post on Linkedin talking about what non-Israeli people should expect when working with Israelis (and especially if they visit Israel for business). It’s a very nice read and it’s not long. After reading it (and laughing to myself, as it’s quite accurate), I decided to write this post. Most of the people that read my blog are spread around the world, and the culture difference between countries is truly interesting.
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!
A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know.
When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes.
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.