Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS Performance Tuning/ SQL Tuning Examples/ Cases: Modifying Statements That Cannot Be Pushed Down

Updated on 2026-05-29 GMT+08:00

Cases: Modifying Statements That Cannot Be Pushed Down

Case: Pushing Down Sort Operations to DNs

Cases: WITH-RECURSIVE Contains Only VALUES RTE Is Not Shippable

Case: WITH-RECURSIVE Contains System Table Is Not Shippable

Case: Subplan Exec on CN Can Not Be Shipped

Case: Type of Record in TargetList Can Not Be Shipped

Case: Type of Record in Non-real Table Can Not Be Shipped

Case: Main Plan Exec on CN and Subplan Exec on DN Can Not Be Shipped

Cases: WITH-RECURSIVE under Multi-nodegroup Scenario Is Not Shippable

Case: WITH-RECURSIVE Contains Conflict Distribution in None-RECURSIVE (Xxx) RECURSIVE (Xxx)

Case: Table in TargetList Can Not Be Shipped

Case: "Row () Expression" Can Not Be Shipped

Case: MERGE INTO Can't Be Shipped in the Sence Temporarily

Case: The Type of Record in DUAL That Is Not a Real Table Can Not Be Shipped

Parent Topic: SQL Tuning Examples

Previous topic: Case: Adding NOT NULL for JOIN Columns

Next topic: Case: Pushing Down Sort Operations to DNs

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.