检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 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/ Developer Guide(Centralized_V2.0-8.x)/ SQL Optimization/ Hint-based Optimization
      Updated on 2025-05-29 GMT+08:00
      View PDF
      Share
      • x.com
      • Facebook
      • LinkedIn
      • Copy link

      Copied.

      Hint-based Optimization

      • Plan Hint Optimization
      • Hints for Specifying the Query Block Where the Hint Is Located
      • Hints for 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
      • Hints for Selecting the Custom Plan or Generic Plan
      • Hints Specifying Not to Expand Subqueries
      • Hint Specifying Not to Use Global Plan Cache
      • Hints of Parameterized Paths at the Same Level
      • Hints for Setting Slow SQL Control Rules
      • Hint for Adaptive Plan Selection
      • Hints for Materializing a Sub-plan Result
      • Bitmap Scan Hints
      • Hints for Inner Table Materialization During Join
      • AGG Hint
      • Query Rewriting Hints
      • Outline Hints
      • Hints for Specifying ANY Sublink Pullup
      • Hints for Specifying the Degree of Parallelism for Scans
      • Hints for Specifying Whether to Use Semi-Join
      • Hints for Specifying the Stream Hashagg Optimization
      • Hints for Specifying Whether to Use Minmax Optimization
      • Hints for Specifying Whether to Use Partition-wise Scan Optimization
      Parent topic: SQL Optimization

      Previous topic: Configuring Key Parameters for SQL Optimization

      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.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