TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
Is your feature request related to a problem? Please describe:
This issue will optimize the query performance for metadata-related statements
Scenario1:
SELECT column_name
FROM information_schema.statistics
WHERE index_name = 'PRIMARY'
AND table_schema = database()
AND table_name = 'xx'
ORDER BY seq_in_index;
Scenario2:
SELECT table_comment
FROM information_schema.tables
WHERE table_schema = database() AND table_name = 'xxx'
Scenario3:
SELECT table_name
FROM information_schema.tables
WHERE table_schema = database() AND table_type = 'xxx'
Describe the feature you'd like:
Speed up the query for metadata to be executed more quickly.
Feature Request
Is your feature request related to a problem? Please describe:
This issue will optimize the query performance for metadata-related statements
Scenario1:
Scenario2:
Scenario3:
Describe the feature you'd like:
Speed up the query for metadata to be executed more quickly.