Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Index Question 1

Status
Not open for further replies.

sohrab100

Programmer
Jan 18, 2002
56
HK
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
 
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 [trooper]
 
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
 
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 [trooper]
 
Hi!
I seem to remember that rushmore takes advantage of indexes, even once you create a cursor with select* etc.
-Bart
 
Nifrabar,

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

can speed up the performance in rushmore?

sohrab100
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top