INDEXED BY

SQL As Understood By SQLite

[Top]

INDEXED BY

The INDEXED BY phrase forces the SQLite query planner to use a particular named index on a DELETE, SELECT, or UPDATE statement. The INDEXED BY phrase is an SQLite extension and is not portable to other SQL database engines.

qualified-table-name: hide

The "INDEXED BY index-name" phrase specifies that the named index must be used in order to look up values on the preceding t