HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

SQL Hints

Availability

This feature is available as of MogDB 1.1.0.

Introduction

SQL hints can be used to override execution plans.

Benefits

Improves SQL query performance.

Description

In plan hints, you can specify a join order; join, stream, and scan operations, the number of rows in a result, and redistribution skew information to tune an execution plan, improving query performance.

Enhancements

Support planhint to set session-level optimizer parameters.

Support specifying subqueries not to be expanded.

Support disabling gpc for single query.

Constraints

None

Dependencies

None

Hint Based Tuning

Copyright © 2011-2024 www.enmotech.com All rights reserved.