Situation: A FE Access database with linked tables to a MS SQL Server BE.
A table with 119850 records that will go over a million records in a year or two.
The table has a Primary key.
Two other fields in the table are searched normally.
To make the search faster, I'm trying to add index for these two fields.
Which one is preferred?
Unique or Non Clustered Index?
Thanks.
A table with 119850 records that will go over a million records in a year or two.
The table has a Primary key.
Two other fields in the table are searched normally.
To make the search faster, I'm trying to add index for these two fields.
Which one is preferred?
Unique or Non Clustered Index?
Thanks.