A
Anne
Does MS Access support index clustering?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry Whittle
In a word: No. Or if it does, there's no real way to tune it such as in
Oracle.
About the best that you can do is index what is needed and not index what
isn't.
Also Access has a bad habit of creating indexes where the table names
include ID, key, code, or num. For example if you create a field called
Pers_id Access will create an index. If the Pers_id field is also the primary
key, Access will create two indexes for this one field. It will also index
Zipcode even though you don't want it to. This is controlled under Tools,
Options, Tables/Queries tab.
I once created, deleted, appended, and updated records on a large table with
an index. I timed a query that used the index. Next I deleted the index then
recreated it. There was an ever so slight performance increase.
Oracle.
About the best that you can do is index what is needed and not index what
isn't.
Also Access has a bad habit of creating indexes where the table names
include ID, key, code, or num. For example if you create a field called
Pers_id Access will create an index. If the Pers_id field is also the primary
key, Access will create two indexes for this one field. It will also index
Zipcode even though you don't want it to. This is controlled under Tools,
Options, Tables/Queries tab.
I once created, deleted, appended, and updated records on a large table with
an index. I timed a query that used the index. Next I deleted the index then
recreated it. There was an ever so slight performance increase.
A
aaron.kempf
Jerry
correction-- that is just about the ONLY feature in Access that I
like.
That is a life saver... for sure.
-Aaron
correction-- that is just about the ONLY feature in Access that I
like.
That is a life saver... for sure.
-Aaron
T
Tom Ellison
Dear Anne:
Mr. Whittle's response is true if you limit the case to the Jet database
engine. Access also comes with a version of SQL Server, which does cluster
"live". The Access Jet database ending only performs this function when you
compact and repair, which may be of some help, however.
Tom Ellison
Microsoft Access MVP
Mr. Whittle's response is true if you limit the case to the Jet database
engine. Access also comes with a version of SQL Server, which does cluster
"live". The Access Jet database ending only performs this function when you
compact and repair, which may be of some help, however.
Tom Ellison
Microsoft Access MVP