Databases Reference
In-Depth Information
The second query, in step 7, requires a FTS and a
HASH
UNIQUE
operation. It uses the
index instead of the table, so the FTS is avoided in favor of an Index Fast Full Scan and
is faster (there are fewer blocks to read).
