Subject | Interbase index question.... |
---|---|
Author | Gordon Hamm |
Post date | 2001-07-19T22:24:57Z |
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
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