vendredi 22 mai 2015

Two fields index

I've got next query:

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);

That means SELECT * FROM companies WHERE address LIKE city% AND name LIKE %query%; How can I create an index for that? I did following:

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

But my index should contain one more field. How can I do that?

Aucun commentaire:

Enregistrer un commentaire