Hi all,

I have a qeury relating to multi column index.

CREATE TABLE EMPLOYEE (ID INT, NAME TEXT);
CREATE INDEX IDX ON EMPLOYEE(ID, NAME);
SELECT * FROM EMPLOYEE WHERE ID > 10 AND NAME < "MAC"

Does the above select statement use index IDX? If yes then how does comparison function evaluates the condition specified in WHERE clause?

What database server are you using? SQL Server? Oracle? Something else?
Indexes may be handled differently by different vendors, so post your question in the appropriate forum.

sisharma

Indexes are handled differently by each vendor, that's where a significant part of the competitive edge is implemented.

However, indexing a TEXT column is a bit insane, IDX is 100% width (text column size) of the table; variable length and slow. Some vendors cannot index text columns at all. Make the indexed column CHAR(255) or something reasonable.