I agree with John. The trade off in size and update speed are almost always outweighed by the ability to quickly query/report your filtered and sorted data.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 18 Jan 2016 17:41:32 +0100
Subject: Re: [MS_AccessPros] Indexed
Yes to both questions.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 18 Jan 2016 17:41:32 +0100
Subject: Re: [MS_AccessPros] Indexed
Yes to both questions.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 18, 2016, at 5:38 PM, sarahk@schemesoftware.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: Duane Hookom <duanehookom@hotmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar