Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary, candidate key ?? speed?
Message
From
27/01/2002 08:24:31
 
 
To
27/01/2002 07:41:27
General information
Forum:
Visual FoxPro
Category:
Contracts, agreements and general business
Miscellaneous
Thread ID:
00611233
Message ID:
00611238
Views:
20
>Hi,
>I read couple of articles that talk about primary key, and it mentioned that we should use integer as primary key and don try to re-use it. If we need something unique such as ID number or customer code, we could place it as candicate key. It is the same effect.
>
>I am not very clear about:
>1. Since, filtered index is not optimize, how am I going to re-use the deleted candicate key but not effect the speed?

Your Candidate key can have a filter, and you can have another TAG on the same field but without the filter.


>
>2. If I have a auto-generated field like Invoice No., do yoo think it is good to be primary key or candicate key??

Sounds like a good choice.


>
>Thank you
Previous
Reply
Map
View

Click here to load this message in the networking platform