Skip to main content

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

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.