java - 两个字段索引

Question

我有下一个查询:

Cursor cursor = ES09SQLiteHelper.getDatabase()
            .query(CompanyDomain.TABLE_NAME,
                    allColumns,
                    CompanyDomain.ADDRESS + " LIKE ? AND "
                            + CompanyDomain.NAME + " LIKE ?",
                    new String[] { Cities.TATARSTAN + city + "%",
                            "%" + query + "%" }, null, null, null);

这意味着SELECT * FROM Companies WHERE address LIKE city% AND name LIKE %query%;我如何为此创建索引？我做了以下事情:

database.execSQL("CREATE INDEX company_address_index ON "
                + CompanyDomain.TABLE_NAME + "(" + CompanyDomain.ADDRESS
                + " COLLATE NOCASE)");

但是我的索引还应该包含一个字段。我怎样才能做到这一点？

Answer 1

database.execSQL("CREATE INDEX company_address_index ON "
                + CompanyDomain.TABLE_NAME + "(name, address 
                + " COLLATE NOCASE)");

或者在普通的 SQLite 中:

CREATE INDEX [name-of-index] ON [table-name]([column1] , [column2] , ...)