Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as
SELECT * FROM EMPLOYEE WHERE EMPID="005"
and the table data be like
EMPID EMPNAME EMPAGE
001 ABC 20
002 AAA 21
003 ABB 23
004 BBB 20
005 BDF 24
006 EEE 22