Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use AGAIN
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00414481
Message ID:
00417989
Views:
29
>If a user has USE TABLE in 0 Shared and indexes on NAME, will this affect the speed on another user that shares this table and indexes on CITY? In other words, does the second user has to wait until the first users finishes his index or using the table?

The user will need to have the table EXCLUSIVE to create an index unless the index is local. In this case, it will take longer for user two to create the index, but he won't have to wait for user one before creating the index.
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