> > From: Bennett Haselton
> >
> > My databases textbook from college says that specifying an
> > attribute as an
> > "index" means that the data will be stored in such a way that
> > lookups on
> > that attribute are faster, and specifying an attribute as a
> > "key" means
> > that its values hav
> From: Bennett Haselton
> My databases textbook from college says that specifying an
When I read my post I saw that I had made at least one obvious error.
Please change:
"An index is conceptually a container of keys arranged in such a way that
each key in the index refers to a unique record.
> From: Bennett Haselton
>
> My databases textbook from college says that specifying an
> attribute as an
> "index" means that the data will be stored in such a way that
> lookups on
> that attribute are faster, and specifying an attribute as a
> "key" means
> that its values have to be unique.
I don't think that's entirely true. MSAccess doesn't refer to indexes, only
keys... and keys in access can be unique or non-unique based on your key
properties. This is identical to how MySQL treats the terms.
Chris
>What are the *standard* meanings of these terms? The usage in the textbook
ma
