Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Error 1884
Message
From
05/04/2016 10:52:26
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
05/04/2016 10:48:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01634277
Message ID:
01634325
Views:
27
>>>INDEX... for disables Rushmore optimization
>>
>>I don't think so, Bill
>>
>>Help reads
>>
>>When Visual FoxPro can determine that a query should not return deleted or undeleted records, and if no unfiltered index is present, it uses INDEX ON <expression> ... FOR DELETED() or INDEX ON <expression> FOR NOT(DELETED()). 
>>
>>For example, the following queries are now optimized:
>>
>
>Hi Gregory
>
>The help on "Using Rushmore Query Optimizations to Speed Data Access" topic says that "Rushmore can use any open indexes except for filtered and UNIQUE indexes."
>
>I've searched what you posted, but can't find it. Can you, please, the topic name in which it is mentioned?
>
>Thanks.-

the page is
Indexes Based on Deleted Records

search on FOR DELETED will bring it up.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform