Over the last 20 years or so I’ve had the opportunity to help build a variety business intelligence solutions for large organizations. It will be no surprise that one of the core requirements is fast query response times. This
requirement for fast response times seems pretty obvious – faster response timeslead to greater end user satisfaction. The
performance of a database can also determine what types of applications are practical. Breakthroughs in performance
often lead to innovating new applications that can change how people work. A more efficient application is usually less
expense to operate since it might not require as large of a server.
Oracle Database In-Memory and the availability of more powerful servers
with many cores and plenty of memory really is a game changer, when it comes to improving query response times. With Database In-Memory far fewer CPU cycles are used to scan, filter, join and aggregate data. With modern servers, there are plenty of CPU cycles available for processing and DRAM is relatively inexpensive. So, Database In-Memory can do more with less and, since Database In-Memory is a feature of the Oracle Database that works with all of the others performance enhancing features of the Oracle Database, it has become yet another tool in my big tool box of performance improving techniques.