Subject Interbase index question....
Author Gordon Hamm
Question..

If I have a query like...

SELECT * FROM CALL_LOG WHERE CUSTID='123456' AND PIN='1235'


What is the best way to index.. In the desktop world, you would create an
index on CUSTID+PIN

In interbase, wouldnt you still do that? or Create on index on just CUSTID
and another on PIN...


Or , since I will commonly search like....
SELECT * FROM CALL_LOG WHERE CUSTID='123456' AND PIN='1235'

SELECT * FROM CALL_LOG WHERE PIN='1235'

SELECT * FROM CALL_LOG WHERE CUSTID='123456'

SELECT * FROM CALL_LOG WHERE CUSTID='123456' AND ANI='5036448888'

SELECT * FROM CALL_LOG WHERE ANI='5036448888'


so, would it be best to create 5 different indexs since I am going to use
these indexes commonly ??
I.E.

CUSTID
CUSTID+PIN
CUSTID+ANI
PIN
ANI

I know this isnt exactly a IBO question ..

Gordon Hamm