Does TiDB Support Extended Statistics (Oracle)

Translated
1

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

Original topic: TiDB是否支持Extended Statistics（Oracle）

| username: alfred

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】
【Encountered Issues】
【Reproduction Path】What operations were performed to cause the issue
【Issue Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • 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 the terminal output and copy-paste it for upload.

2
| username: ddhe9527 | Original post link

Not supported, TiDB does not have multi-column statistics, only partial column statistics, with the aim of reducing the overhead of collecting statistics.

3
| username: h5n1 | Original post link

Support for extended statistics is not GA yet. Tested on version 6.1:

image
image1072×746 25.9 KB

4
| username: alfred | Original post link

There is a certain degree of similarity with Oracle.

5
| username: system | Original post link

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