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

Updated on 2026-01-04 GMT+08:00

View PDF

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't 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't 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.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.