Querying Index in SQLite

Question

How can I perform query on Index in SQLite

Javeed M Shaikh · Answer

Hi Monika I think you cannot use indexes directly in SQLite instead you only create them for the columns you choose from a table. You will probably want to index columns such as primary and foreign keys columns which you often include in your where clauses and so on.