Unique OR Index? (1 Viewer)

deletedT

Guest
Local time
Today, 14:41
Joined
Feb 2, 2019
Messages
1,218
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.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:41
Joined
Oct 29, 2018
Messages
21,358
Hi. I’m not sure I follow, those two are not exclusive of each other. You can combine the two because an index is separate from a constraint.
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 01:41
Joined
Jan 20, 2009
Messages
12,849
Unique means that no two records can have the same value in the column.
Obviously you don't want this if two records can have the same value.

Only one index can be clustered, normally it will be the PK.
 

deletedT

Guest
Local time
Today, 14:41
Joined
Feb 2, 2019
Messages
1,218
I'm reading a SQL bible and it seems I've misunderstood and lost somewhere.
For sure it means I need to learn English first.:(
I'll read the chapter again and will re-phrase my question as soon as I'm finished.

Thanks
 

Users who are viewing this thread

Top Bottom