revscan
Short Description
The revscan operator shows details of the index being scanned in the reverse direction
Detailed Description​
The revscan operator shows details of the index being scanned in reverse direction.
It is possible to force a reverse index scan with a hint, otherwise the cost based optimizer will choose the most efficient direction.
When a reverse scan is used the explain plan will show
scan [table], rev
Additional Links​
- CockroachDB Docs - Force reverse scan
- 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.