Hi All,
I am attempting to improve performance on my DB by introducing indexes for commonly searched/ filtered fields. I know in Oracle indexing foreign keys is a necessity, and was curious if Access indexes foreign keys on its own. When selecting foreign key in design view it doesn't say it is indexed, so just wanted to check if this is done behind-the-scenes and if this is a also a necessity in Access.
Thank you,
Skid