java双字段索引
我有下一个问题:
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)");
但我的索引应该再包含一个字段。我该怎么做
# 1 楼答案
或者在纯SQLite中: