Easy Tutorial
Sqlite Alias Sqlite Like Clause Sqlite Syntax Sqlite Php Sqlite Distinct Keyword Sqlite Functions Sqlite Autoincrement Sqlite Detach Database Sqlite Unions Clause Sqlite Attach Database Sqlite Joins Sqlite Pragma Sqlite Group By Sqlite Where Clause Sqlite Injection Sqlite And Or Clauses Sqlite Operators Sqlite Constraints Sqlite Drop Table Sqlite C Cpp Sqlite Order By Sqlite Subquery Sqlite Expressions Sqlite View Sqlite Indexed By Sqlite Alter Command Sqlite Insert Sqlite Select Sqlite Explain Sqlite Python Sqlite Installation Sqlite Transaction Sqlite Update Sqlite Delete Sqlite Commands Sqlite Date Time Sqlite Null Values Sqlite Create Table Sqlite Java Sqlite Data Types Sqlite Trigger Sqlite Create Database Sqlite Limit Clause Sqlite Intro Sqlite Truncate Table Sqlite Vacuum Sqlite Perl Sqlite Glob Clause Sqlite Index Sqlite Tutorial Sqlite Having Clause
❮ Sqlite View Sqlite Alter Command ❯

SQLite Indexed By

The "INDEXED BY index-name" clause specifies that the named index must be used to look up values in the preceding table.

If the index name index-name does not exist or cannot be used for the query, the preparation of the SQLite statement fails.

The "NOT INDEXED" clause specifies that no index is to be used when accessing the preceding table, including implicit indexes created by UNIQUE and PRIMARY KEY constraints.

However, even if "NOT INDEXED" is specified, the INTEGER PRIMARY KEY can still be used to find entries.

Syntax

Below is the syntax for the INDEXED BY clause, which can be used with DELETE, UPDATE, or SELECT statements:

SELECT|DELETE|UPDATE column1, column2...
INDEXED BY (index_name)
table_name
WHERE (CONDITION);

Example

Assume there is a table COMPANY, and we will create an index and use it for an INDEXED BY operation.

sqlite> CREATE INDEX salary_index ON COMPANY(salary);
sqlite>

Now, use the INDEXED BY clause to select data from the COMPANY table as follows:

sqlite> SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;
❮ Sqlite View Sqlite Alter Command ❯