Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Internal architecure of indexes in MS-Access Expand / Collapse
Posted Friday, May 24, 2013 4:32 AM


Group: General Forum Members
Last Login: Monday, April 20, 2015 3:08 AM
Points: 424, Visits: 1,607
Hi All,

please help me on the below basic question:
Is MS-Access db will keep the structure of index as b-tree?


Post #1456375
Posted Friday, May 24, 2013 7:22 AM


Group: General Forum Members
Last Login: 2 days ago @ 3:12 PM
Points: 196, Visits: 776
To my knowledge Microsoft has not divulged the internal structure of indexes in any version of Access. And there are at least 4 distinct versions of the JET engine that have been released, and with 2007, 2010 and 2013 there is a new engine called ACE. The indexing technology does use "Rushmore" optimization to speed data retrieval, and there are numerous articles on both that and the engine versions that can be found with a web search.

Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1456487
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse