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?.

---In, <duanehookom@...> wrote :

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

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?



Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)



Tidak ada komentar:

Posting Komentar