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
Author
Message
Posted Friday, May 24, 2013 4:32 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, December 11, 2014 2:19 AM
Points: 415, Visits: 1,605
Hi All,

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


Thanks,


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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 170, Visits: 630
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.

Wendell
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