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.
If you are
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.
If
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.
But MySQL seems to use KEY and INDEX to
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