检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn

不再显示此消息

  • Intl-English
    International
    • English
    • Bahasa Indonesia
    • Español
    • Português
    • Türkçe
    • عربي
    • ไทย
    • 简体中文
    • 日本語
    中国站
    • 简体中文
    Europe
    • English
    • Deutsch
    • Español
    • Français
    • Nederlands
  • Huawei Cloud
    • Activities
    • Products
    • Solutions
    • Pricing
    • KooGallery
    • Partners
    • Developers
    • Support
    • About Us
      Show more results for “”
      • Contact Us
      • Documentation
      • Console
        • My Account
        • Billing & Costs
        • Service Tickets
        • Unread Messages
        • Console
        • Partner Center
        • Sign In Sign Up
      • Sign In
      • Sign Up
        • My Account Complete Sign Up
        • Billing & Costs
        • Service Tickets
        • Unread Messages
        • Console
        • Partner Center
        • Log Out
      Cancel
      Help Center/ GaussDB(DWS)/ Developer Guide/ Developer Guide (9.1.0.x)/ GaussDB(DWS) Performance Tuning/ SQL Tuning Examples
      Updated on 2025-07-22 GMT+08:00
      View PDF
      Share
      • x.com
      • Facebook
      • LinkedIn
      • Copy link

      Copied.

      SQL Tuning Examples

        Case: Selecting an Appropriate Distribution Column
        Case: Creating an Appropriate Index
        Case: Adding NOT NULL for JOIN Columns
        Case: Pushing Down Sort Operations to DNs
        Case: Configuring cost_param for Better Query Performance
        Case: Adjusting the Partial Clustering Key
        Case: Adjusting the Table Storage Mode in a Medium Table
        Case: Reconstructing Partition Tables
        Case: Adjusting the GUC Parameter best_agg_plan
        Case: Rewriting SQL Statements and Eliminating Prune Interference
        Case: Rewriting SQL Statements and Deleting in-clause
        Case: Setting Partial Cluster Keys
        Case: Converting from NOT IN to NOT EXISTS
      Parent Topic: GaussDB(DWS) Performance Tuning

      Previous topic: Query Band Load Identification

      Next topic: Case: Selecting an Appropriate Distribution Column

      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.

      Chatbot
      Contact Sales After-Sales Self Service
      • Site Terms
      • Privacy Statement

      Explore Huawei Cloud

      Why Us Customer Stories Trust Center Legal Press Releases

      Featured Services

      Elastic Cloud Server (ECS) Elastic IP (EIP) RDS for MySQL Elastic Volume Service (EVS) MapReduce Service (MRS)

      Service and Support

      Documentation Contact Us Public Notices Support Plans Service Health Dashboard

      Account and Payment

      Top Up Invoices Billing Center My Account Payment Method

      Quick Links

      Huawei Corporate Huawei Enterprise Huawei Consumer Business Huawei Developers

      © 2025, Huawei Cloud Computing Technologies Co., Ltd. and/or its affiliates. All rights reserved.

      • Site Terms
      • Privacy Statement