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

不再显示此消息

  • EU-English
    Europe
    • English
    • Deutsch
    • Español
    • Français
    • Nederlands
    International
    • English
    • Bahasa Indonesia
    • Español
    • Português
    • Türkçe
    • عربي
    • ไทย
    • 简体中文
    • 日本語
    中国站
    • 简体中文
  • Huawei Cloud
    • Products
    • Solutions
    • Pricing
    • KooGallery
    • Partners
    • Developers
    • Support
    • About Us
    Hot
    • Elastic Cloud Server (ECS)
    • Cloud Backup and Recovery (CBR)
    • Host Security Service (HSS)
    • Cloud Container Engine (CCE)
      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
        • Billing & Costs
        • Service Tickets
        • Unread Messages
        • Console
        • Partner Center
        • Log Out
      Cancel
      Hot
      • Elastic Cloud Server (ECS)
      • Cloud Backup and Recovery (CBR)
      • Host Security Service (HSS)
      • Cloud Container Engine (CCE)
      Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ SQL Optimization/ Hint-based Tuning
      Updated on 2025-08-19 GMT+08:00
      View PDF

      Hint-based Tuning

      • Plan Hint Optimization
      • Hint Specifying the Query Block Where the Hint Is Located
      • Hint Specifying the Query Block and Schema of a Table
      • Join Order Hints
      • Join Operation Hints
      • Rows Hints
      • Stream Operation Hints
      • Scan Operation Hints
      • Sublink Name Hints
      • Hint Errors, Conflicts, and Other Warnings
      • Optimizer GUC Parameter Hints
      • Hint for Selecting the Custom Plan or Generic Plan
      • Hints Specifying Not to Expand Subqueries
      • Hint Specifying Not to Use Global Plan Cache
      • Hint of Parameterized Paths at the Same Level
      • Hint for Setting Slow SQL Control Rules
      • Hint for Adaptive Plan Selection
      • Hint for Materializing a Sub-plan Result
      • Bitmap Scan Hints
      • Hint for Inner Table Materialization During Join
      • AGG Hint
      Parent topic: SQL Optimization

      Previous topic: Configuring Key Parameters for SQL Tuning

      Next topic: Plan Hint Optimization

      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.

      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
      Contact Sales After-Sales Self-Service
      • Cookie Settings
      • 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 Self-Service Contact Us Public Notices Support Plans

      Account and Payment

      Charge/Payment Invoices Billing Center My Account Payment Method

      Quick Links

      Huawei Corporate Huawei Enterprise Huawei Consumer Business Huawei Developers

      © Sparkoo Technologies Ireland Co. Limited 2025

      Company Name: Sparkoo Technologies Ireland Co. Limited, a private company limited by shares.

      Company address: 2nd Floor, Mespil Court, Mespil Road, Ballsbridge, Dublin 4, D04 E516, Ireland

      Email address: eucloud@huaweicloud.com

      Company registration number: 709764

      Company VAT number: IE3921024FH

      • Cookie Settings
      • Cookie Policy
      • Site Terms
      • Privacy Statement