Skip to main content
Regatta home page
Search...
⌘K
Support
Start Coding
Start Coding
Search...
Navigation
Join hints
Join hints
Docs Home
Quickstart
SQL
Regatta Cloud
Self-Hosted Deployment
Drivers & Clients
Tuning Performance
SQL Specification
Introduction
Data Types
Introduction
Numeric types
Character types
Date/Time types
Boolean types
Type Conversion
ROW IDs
SQL Syntax Conventions
SQL Syntax Conventions
Data Definition Language (DDL) Commands
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Manipulation Language Commands
INSERT
UPDATE
DELETE
Transaction Control Language Commands
Transaction Control Language Commands
SET TRANSACTION
Data Query Language
SELECT
EXPLAIN
Hints
Overview
General notes
Join hints
Join hints
Hint - Join direction
Hint - Join method
Hint - Join distribution method
Hints for parallelism of distributed operations
Other hints
SQL Functions and Operators
SQL Functions and Operators
Comparison Functions and Operators
Mathematical Functions and Operators
String Functions and Operators
Date/Time Functions and Operators
Conditional Expressions
Convert Functions
Aggregate Functions
Subquery Expressions
Managing Users
CREATE USER
ALTER USER
DROP USER
System Monitoring
Using System Monitoring Views
SHOW SYSTEM VIEWS
Database Catalog Data
System Catalog Data
Dynamic System Data
System Management
Appendices
Identifiers Limitations
Database Limitations
Reserved Words
Join hints
Join hints
Join hints can be applied only to explicit joins. In order to use join hints, the join result must be aliased and the alias name specified in the hint to identify the join.
Was this page helpful?
Yes
No
General notes
Hint - Join direction
⌘I
