>I'm just now implementing views for the first time and am wondering about indexing considerations. I'm assuming there isn't much difference in performance when updating indexes either in a view or a table except for the initial creation of the view index. When the view is USED I understand that any indexes have to be created in code. After that is there any difference in how quickly the view's indexes get updated whenever a record is modified?
It is possible that the view will be entirely in memory, in which case, the view will update faster. However, VFP automatically uses the disk when needed to hold the view. So, for all practical purposes, there is no difference.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer