Improve the availability of temporary table

## Feature Request

**Is your feature request related to a problem? Please describe:**

In the big data table cases, the temporary table can not support the big transactions and write disk to persist data, and table statistics.

**Describe the feature you'd like:**

I'd like these cases can be supported.

**Describe alternatives you've considered:**

N/A
**Teachability, Documentation, Adoption, Migration Strategy:**

The issue names no files, tests, or entry points; start by locating temporary-table handling and its existing tests, then trace how large transactions, disk persistence, and statistics are currently handled. Done means the stated big-table cases are supported, with regression coverage for transaction size, disk persistence, and table statistics.

Written by the indexing model from the issue text.