Do both logical optimization and physical optimization occur during the compilation process?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 逻辑优化和物理优化是否都发生在编译操作中

| username: alfred

To improve efficiency, please provide the following information. Clear problem descriptions can be resolved faster:
[TiDB Usage Environment]

[Overview] Scenario + Problem Overview

[Background] Operations performed

[Phenomenon] Business and database phenomena

[Problem] Current issues encountered

[Business Impact]

[TiDB Version]

[Application Software and Version]

[Attachments] Relevant logs and configuration information

  • TiUP Cluster Display information
  • TiUP Cluster Edit config information

Monitoring (https://metricstool.pingcap.com/)

  • TiDB-Overview Grafana monitoring
  • TiDB Grafana monitoring
  • TiKV Grafana monitoring
  • PD Grafana monitoring
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: yilong | Original post link

Yes.
Additionally, you can check out this document: TiDB 源码阅读系列文章（七）基于规则的优化 | PingCAP

3
| username: 特雷西-迈克-格雷迪 | Original post link

Yes, logical optimization includes condition folding and equivalent condition transformation; physical optimization generates execution plans through statistical information.

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.