Table Index Question 1

[sohrab100]

Will a table with two index on one field make the search faster?

Example

TableA
Index on FieldA tag FieldAIDX1
Index on FieldA tag FieldAIDX2

Will it be faster or no effect? or make slower even because of wasted index?


sohrab100

 

[torturedmind]

correct me if am wrong abt this but, as i understand this, you can only have one index open per table. this means that if you have indeces on one table no matter how many there are, one and only one can be opened per work area. and there will be no changes in the performance of your SEEK() or FIND() functions. this is in VFP6 of course. i dunno abt higher VFP vrsions.

kilroy

 

[sohrab100]

That's what i guess for Seek(), Find(). But what if i issue a SQL as follow

select * from tablea where fielda="abc"

Will the indexs of FieldAIDX1, FieldAIDX2 help for the sql?
or just the same as one index only?

PS:
Index on FieldA tag FieldAIDX1
Index on FieldA tag FieldAIDX2


sohrab100

 

[torturedmind]

actually, your indeces wont help at all since the table used in the query is opened as "AGAIN" (like USE MyTable AGAIN IN 0).

kilroy

 

[jimstarr]

The second index won't speed things up. -Jim

 

[Nifrabar]

Hi!
I seem to remember that rushmore takes advantage of indexes, even once you create a cursor with select* etc.
-Bart

 

[sohrab100]

Nifrabar,

Do u means
Index on FieldA tag FieldAIDX1
Index on FieldA tag FieldAIDX2

can speed up the performance in rushmore?

sohrab100