Post reply

Internal architecure of indexes in MS-Access

  • May 24, 2013 at 4:32 am

    #74372

    Hi All,

    please help me on the below basic question:

    Is MS-Access db will keep the structure of index as b-tree?

    Thanks,

    🙂

  • May 24, 2013 at 7:22 am

    #1618266

    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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply