My Oracle Support Banner

Queries that use a MergeJoin strategy take a considerable amount to time to complete (Doc ID 1550731.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.3.0 and later
Information in this document applies to any platform.

Symptoms

Certain queries and  UPDATEs that include queries involving multiple tables  perform very poorly and may take a considerable amount of time to complete.

The query plan  shows  one step using a MergeJoin and is an indication that it may be the reason for the poor performance.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.