In SQLite, an Index is a pointer to specific columns in a table that enable super-fast retrieval.

Note: The database size can increase significantly, however if performance is more important, the tradeoff is worth it.

Indexes are defined using the indexGroups() property of the @Table annotation. These operate similar to how UniqueGroup work:

  1. specify an @IndexGroup
  2. Add the @Index
  3. Build and an IndexProperty gets generated. This allows super-easy access to the index so you can enable/disable it with ease.

Note: Index are not explicitly enabled unless coupled with an IndexMigration. (read here).

You can define as many @IndexGroup you want within a @Table as long as one field references the group. Also individual @Column can belong to any number of groups:

@Table(database = TestDatabase.class,
       indexGroups = [
               @IndexGroup(number = 1, name = "firstIndex"),
               @IndexGroup(number = 2, name = "secondIndex"),
               @IndexGroup(number = 3, name = "thirdIndex")
public class IndexModel2 {

   @Index(indexGroups = {1, 2, 3})
   int id;

   @Index(indexGroups = 1)
   String first_name;

   @Index(indexGroups = 2)
   String last_name;

   @Index(indexGroups = {1, 3})
   Date created_date;

   @Index(indexGroups = {2, 3})
   boolean isPro;

By defining the index this way, we generate an IndexProperty, which makes it very easy to enable, disable, and use it within queries:

  .where(...); // do a query here.

IndexModel2_Table.firstIndex.drop(); // turn it off when no longer needed.


(select from IndexModel2::class indexedBy IndexModel2_Table.firstIndex where (...))

IndexModel2_Table.firstIndex.drop() // turn it off when no longer needed.

SQLite Index Wrapper

For flexibility, we also support the SQLite Index wrapper object, in which the IndexProperty uses underneath.

Index<SomeTable> index = SQLite.index("MyIndex")
    .on(SomeTable.class,, SomeTable_Table.othercolumn);

// do some operations

index.disable(); // disable when no longer needed

val index = indexOn<SomeTable>("MyIndex",, SomeTable_Table.othercolumn)


results matching ""

    No results matching ""