Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
From
10/03/1999 14:45:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is it reasonable to have index on DELETED()?
Miscellaneous
Thread ID:
00196021
Message ID:
00196021
Views:
84
I'm using a lot of sql selects to select data from big free dbfs.
Those tables have very few deleted records and where clauses are written so
that Rushmore finds always a index tag to use.
SET DELETED is ON always.

Will the performance increase if I add

INDEX ON DELETED()

to those tables? Will select queries run then faster?
I have read some recommendations to have index on deleted() in each table
to avoid sequential scanning of the deleted records by select. Is this true?
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform