Shella
October 31st, 1999, 12:32 PM
Hi
I only know to create single-field index and multi-field index to prevent duplicate entries from entering into the Access database. In fact, besides that, how can an Index speed up the sorting of a table ? In Access, we can also do sorting without creating an Index, any evident benefit after creating an index on a field (Besides Uniqueness of the field)?
In Visual Foxpro, after creating an Index, we can c the effect by typing
Set Order To TeacherIndex
List
Thanx in advance.
I only know to create single-field index and multi-field index to prevent duplicate entries from entering into the Access database. In fact, besides that, how can an Index speed up the sorting of a table ? In Access, we can also do sorting without creating an Index, any evident benefit after creating an index on a field (Besides Uniqueness of the field)?
In Visual Foxpro, after creating an Index, we can c the effect by typing
Set Order To TeacherIndex
List
Thanx in advance.