MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 2: MS Access Local & Linked Tables
What is an Index?
Indexes are nothing but a mean to speed up the search process. Whenever
you define to create an index on any column/field in a table, MS Access
creates another implicit table per each index column. This table would
not be visible to you; it will be solely for MS Access. If you have a
table having 100,000 records but without having any index on any column,
once you create an index the size of your database will increase. If you
create index on all the columns of that particular table, the size of
the database will increase in an enormous amount.
So the bottom line is, we create index only on those columns which we
would be using a lot in WHERE clause in the SELECT statement.
Just like Index at the end of each book helps to speed up the search
process, similarly MS Access Indexes help MS Access to speed up the
search process. In other words, the time it takes for MS Access to
return the result of a query based on the indexed column in WHERE clause
will be less compared to without having index on that particular column
in the WHERE clause.
Chapter 2: MS Access Local & Linked Tables
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: