Oracle In-memory Database—Speed and Simplicity Meet Up. Have you tried it out yet?
One of the major announcements Oracle made during the Open World was the launch of Oracle In Memory Database Option. The In-Memory option to Oracle Database 12c is 100 percent compatible with existing applications and leverages all existing Oracle Database...Query Rewrite: What is MySQL Doing To My Queries?
The Impact of Query Rewrite on MySQL Query Optimization When processing a query, every relational database vendor takes a number of similar steps to parse, validate, and optimize a query. MySQL does the following: Validates the query syntax — does it use valid...
Why I Avoid Database Hints: a followup
In an earlier blog post about database hints, I gave a number of reasons why I dont like to use hints in SQL queries. Today I wanted to follow up to share one situation where I think hints are OK, even necessary. As described very well in an article in an article by...