CODEWITHSUNDEEP
iphoneiosxcodesqlite
user973984
user973984

Reputation: 2824

Using SQLite Manager to create indexes

I've created and index named "setIndex" for table "mySets" on column "setID" with the SQLite Manager (firefox). In order for the app to use them in a query, do I have to specify anything like the index name when searching my table?

SELECT * FROM mySets WHERE setID='setMatrix'

Upvotes: 1

Views: 690

Answers (1)

Clafou
Clafou

Reputation: 15400

No, you don't have anything more to do; you can't explicitly make SQLite use an index when running a query. The database engine (SQLite but that goes for all the others) will decide whether to use your index if it's there and if it considers it appropriate to do so.

Upvotes: 1

Related Questions