Message
From
11/09/2006 19:43:58
To
11/09/2006 16:00:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152861
Message ID:
01152900
Views:
23
>If you don't have an index, VFP will have to scan whole table regardless what you do. DELETE-SQL will be even slower because it'll lock/unlock each record.
>
If I add the index, what would be better?
>
If I add the index, what would be better?