Senin, 18 Januari 2016

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, [MS_Access_Professionals] <> 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?.

---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: John Viescas <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)



Tidak ada komentar:

Posting Komentar