General information
Category:
The Mere Mortals Framework
>Ok, lets see if I understand indexing in foxpro:
>If I have a contact table and I want to benefit from rushmore I need to create an index in the table for every field that might be used in a quary including an index on the deleted records.
>If I am using a view to load a form and I want to have control over field order I need to create an index on the fields in the view
>The index on the table has no benefit to me while using he view.
That sounds about right... of course, you only need to index the view if you need to rapidly find records in a view... or, if you want to be able to change the order of the view without requerying... for example you want to list the list by last name or by date.
If you always want to see the records in a certain sequence, just ORDER the view.. this will be faster than building an index on the view after the fact.
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only