CODEWITHSUNDEEP
androidsqlite
Ian Vink
Ian Vink

Reputation: 68750

Android SQLite Index Optimization

I am optimizing our database for Android SQLite.

The data is simple, 3 ints (Country, State, City) The data is stored in order by Country, State and City.

If I create an index on the three fields in ASC, would that be the most efficient given that we "READ-ONLY" the data 100% of the time by the 3 fields?

Upvotes: 0

Views: 2051

Answers (1)

MPelletier
MPelletier

Reputation: 16657

Database optimisation depends highly on how you query it (i.e. what you query it for). In other words, if you post some queries, I might be able to better answer your question.

Upvotes: 1

Related Questions