SQL Select and primary keys

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I should know this but I dont and cant find an answer via Google...

If my table as a primary key bases on multiple fields and I do a
select with a Where statement using those fields, will the select be
faster because of the primary keys?

Hope that makes sense...

TIA
John
.

Relevant Pages

  • Multiple field primary key and other indexes
    ... I have a database that has multiple fields for it's primary. ... Since any of these 3 fields are used for sorting, ... These three fields are are defined as the primary key. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: setting a multi-field key index
    ... Highlight multiple fields. ... If you are looking to set a multi-field index that is NOT a primary key, ... open the index window and add multiple fields to a single index. ... Microsoft IT Academy Program Mentor ...
    (microsoft.public.access.gettingstarted)
  • Re: Table Troubles
    ... Access supports multi-field primary keys, ... composed of multiple fields. ... you need to enable CascadeUpdates in your ... is common to use two fields for the primary key. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Unique Index
    ... Job Dwg ... I want add a autonumber primary key. ... create an index on job / dwg to allow the drawing field to be unique for ... a unique index on multiple fields that were not a primary key. ...
    (comp.databases.ms-access)
  • Re: Problem with composite key
    ... First, I'm a learner, not an expert and all following advice should be ... Each table has ITS OWN primary key; ... joining the two fields into a third to creat the unique identifier. ... one of the multiple fields can have duplicates. ...
    (microsoft.public.access.tablesdbdesign)