Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Index
Message
From
06/04/2001 08:30:28
 
 
To
05/04/2001 19:58:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00492553
Message ID:
00492741
Views:
28
>>
>>The other camp says that the PK should only be applied to non-deleted records. You can build a filtered index on the PK that ignores deleted records. Keep in mind that a filtered index will not be used by Rushmore.
>
>. . .but of course a second index on the same field but without the filter puts Rushmore into action again.

Yup. Just keep remember there is additional overhead to update a second, and IMO, unneeded index. Don't reuse keys and the problem won't exist.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform