In the previous recipe, we have seen some issues related to FTS operations and when it's better to avoid them.
One of the methods to avoid FTS is indexing. In this recipe, several issues related to index lookup and index scan will be presented along with an illustration of the counterpart for indexes of FTS operation—Index Full Scan.
The examples given are based on a copy of the
CUSTOMERS table in the
SH schema; we will use SQL*Plus to execute our tests.
The following steps will demonstrate index lookup:
MY_CUSTOMERStable as a copy of
CREATE TABLE sh.MY_CUSTOMERS AS SELECT * FROM sh.CUSTOMERS NOLOGGING;