scan
Short Description
The scan operator shows details of the table being scanned
Detailed Description​
The scan operator shows details of the table being scanned.
Slow select operations can be caused by table scanning where a small number of rows selected from a large table. Consider adding an index to support your key queries.
When a reverse scan is used the suffix ,rev will be seen.
Additional Links​
- CockroachDB Docs - SQL Tuning with Explain - Issue: Table Scans
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.