My Oracle Support Banner

What are the Requirements for MySQL Cluster to Push Down Join Conditions?; SPJ (Doc ID 1383501.1)

Last updated on FEBRUARY 26, 2020

Applies to:

MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.

Goal

Learn what the requirements are for a JOIN condition to be pushed down in MySQL Cluster 7.2 and later.


Solution

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
Goal
Solution
 Overview
 Examples
 1. Same Data Type
 2. Columns to Columns
 3. Referencing BLOBs or TEXTs
 4. Locking With FOR UPDATE
 
5. The Join Type Must Be ref, eq_ref, or const
 6. OUTER JOINs
 7. Using Join Buffer
 8. Child Table of a eq_ref Parent


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