What is an index in SQLite?

user_200477 0
Viewed 4462

I don't understand what an index is or does in SQLite. (NOT SQL) I think it allows for sorting in acending and decending order and access to data quicker. But I'm just guessing here.

indexing sqlite
7 Answers

Speed up searching and sorting

Different types of SQLite indices speed up searching and sorting in different ways. The following tutorial explains this in a great way.

user_21924880
Related