CHAPTER6
Optimizing Database In-Memory Queries
You can optimize Database In-Memory queries to gain maximum performance benefits in several ways: by using join groups, In-Memory expressions, and In-Memory aggregations. This chapter shows you how to get the most from these operations.
Using Join Groups
A join group is a dictionary object created by a user that lists or provides details about two columns that can be joined. Join groups are conceptually similar to the materialized views used by the optimizer for query rewrite. A join group is created by a user, which implies that it is not a system object, but something you are going to create to ...
Get Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
