You want to create an index for a specific column, for example, to the name column.

 db.execSQL("CREATE TABLE book (" + "_id INTEGER PRIMARY KEY AUTOINCREMENT," + "name TEXT ," + "autor TEXT" + ");");

    1 answer 1

    index column in the sqlite table can be created like this.

     db.execSQL("CREATE TABLE book (" + "_id INTEGER PRIMARY KEY AUTOINCREMENT," + "name TEXT ," + "autor TEXT" + ");"); db.execSQL("CREATE INDEX bookIndex1 ON book (name);");