O'Reilly logo

Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance by Joyjeet Banerjee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Images

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required