Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Indexing Multiple Keys
0 views
Skip to first unread message
Tim
Jun 9, 2003, 8:28:08 PM6/9/03
to
While working in the table design and selecting multiple
keys, should you index those keys (option above Unicode
Compression)?. I heard that Access automatically assigns
indexes to those keys but I am not sure if I need to add
an index manually
keys, should you index those keys (option above Unicode
Compression)?. I heard that Access automatically assigns
indexes to those keys but I am not sure if I need to add
an index manually
Thanks
John Vinson
Jun 9, 2003, 11:12:27 PM6/9/03
to
On Mon, 9 Jun 2003 17:28:08 -0700, "Tim" <Tim.Be...@gapac.com>
wrote:
wrote:
What do you mean exactly by "selecting multiple keys"? Creating a
multi-field Primary Key? If so, then no: defining a field or fields as
a Primary Key automatically creates a unique Index on that field (or
fields).
You may have cause to index some of the fields independently if you'll
routinely be using them on their own for sorting or searching.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
0 new messages