Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing on multiple fields....
Message
From
11/11/2000 08:38:55
 
 
To
11/11/2000 07:04:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00440691
Message ID:
00440694
Views:
9
>Have someone experienced problemns with multiple field indexes, like: field1 + dtos(field2) + str(field3)... Problemns like: slow indexes, corrupted indexes, etc...
>
>I need that for primary key.
>
>Cause I have developed a database that have until 6 fields concatenated on one single tag, and the tables will have a lot of records (1 million+).
>
>Any experience will be apreciated.
>Thanks.

This isn't a good idea for a primary key. You should look at a surrogate key for a PK. There is an article on my web site that explains how to do this.
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