Thanks Duane.
.
Follow up questions:
Do the indexed fields:
1) increase the size of the database?
2) increase the time it takes to insert/delete records from a table?.
Thanks
Sarah
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
Sarah,
I assume you mean the index property. Adding indexes to fields can speed up queries tremendously. Fields that you use in joins, filters, and/or sorting should be indexed for efficiency.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 14 Jan 2016 15:36:54 -0800
Subject: [MS_AccessPros] Indexed
What is the purpose/significance of the 'indexed' parameter when defining a field in an Access Table?
Sarah
I assume you mean the index property. Adding indexes to fields can speed up queries tremendously. Fields that you use in joins, filters, and/or sorting should be indexed for efficiency.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 14 Jan 2016 15:36:54 -0800
Subject: [MS_AccessPros] Indexed
What is the purpose/significance of the 'indexed' parameter when defining a field in an Access Table?
Sarah
__._,_.___
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar