> ## Documentation Index
> Fetch the complete documentation index at: https://help.teable.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Table Query Ops

> Analyze slow table queries and review possible database improvements.

<Tip>Available for self-hosted Business plan and above</Tip>

Path: Admin Panel → Table Query Ops

Use **Table Query Ops** when views, filters, relations, or searches on a large table become slow. It helps instance administrators analyze a Table, Base, or Space and identify possible improvements.

## Choose an Analysis

| Analysis type         | Use it for                                                                                                              |
| --------------------- | ----------------------------------------------------------------------------------------------------------------------- |
| **Queries & indexes** | Find query risks and possible index improvements.                                                                       |
| **Substring search**  | Check whether a substring search access path could speed up contains searches without changing their matching behavior. |

## Run an Analysis

Choose **Table**, **Base**, or **Space**, then enter the corresponding ID and select an analysis type. Start with **Table** when you already know which table is slow.

Click **Generate query report** or **Generate search report**. The report summarizes detected risks and recommended next actions. For a search report, **EXPLAIN sample search** is optional. Add a sample to check result compatibility, query plans, and repeated query timing for the proposed substring search access path. Teable does not save the sample value.

<Info>The query report does not change the database. Applying a substring search recommendation requires an **EXPLAIN sample search** and administrator confirmation.</Info>

For a large table, review the impact and schedule any confirmed change for a suitable maintenance window.