Do I need a secondary index on a field that is part of a key index

BBus...@DataGuidance.com (Brian Bushay TeamB)

Delphi Developer

Sun, 02 Jan 2000 03:00:00 GMT

Do I need a secondary index on a field that is part of a key index

Quote

>I am using Paradox tables.
>I defined a primary index that is made out of two fields.
>I will need to access the table using the primary index as well as through
>each of the two fields separately. Do I need to define scondary indexes on
>each of the fields?

>--

Just the second field

Brian

Other Threads

1. Adding Secondary Indexes without a Primary Index

2. How to get indexed fileds in a secondary index file at run time

3. How to know if the key violation is in primary or secondary indexes

4. secondary index on datetime fields

5. secondary indices on calculated fields?

6. DESPERATELY NEED HELP WITH SECONDARY INDEXES AND CHILD DATABASES

7. Pdox secondary indexes on single fields

8. Secondary Paradox index on alphanumeric and date field

9. composite secondary index; help needed

10. Setting range criteria for 2nd field in secondary index only (Paradox)