Index and Primary Key

Results 1 to 2 of 2

Thread: Index and Primary Key

  1. #1
    sean1978 Guest

    Default Index and Primary Key

    Hi-<BR><BR>Whats the difference between an Index and a Primary Key? Is there any?<BR><BR>thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Index and Primary Key

    A Primary Key is a CONSTRAINT That enforces unique values e.g. No two records will have the same Primary Key. Can be one field or a combination Fields<BR><BR>While an index is simply a List of values for a specific Field(s) to allow for faster searching by hopefully eliminating the need for a table scan (e.g scan at ALL the records in a table to find the right one)...<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts