Senin, 18 Januari 2016

RE: [MS_AccessPros] Indexed

 


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 :

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:

Poskan Komentar