It takes too long time for query tables with tidb_table_id

[lilinghai]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1.5M databases, 3M tables
We should optimize the execution time of the follow query

mysql> select TABLE_SCHEMA from INFORMATION_SCHEMA.tables where tidb_table_id=200461;
+--------------+
| TABLE_SCHEMA |
+--------------+
| sb10wnormal1 |
+--------------+
1 row in set (14 min 21.65 sec)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master
Release Version: v8.5.0-alpha-230-gca395fa4be
Edition: Community
Git Commit Hash: ca395fa
Git Branch: HEAD
UTC Build Time: 2024-11-27 13:21:51
GoVersion: go1.23.3
Race Enabled: false
Check Table Before Drop: false
Store: tikv