Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    index structures (XP)

    I am looking for documentation on how Access internally does it searches and indexes. I am taking a database class and they are studying the structures of database indexes. Any information or pointers to documentation would be appreciated. Thanks in advance for your help.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: index structures (XP)

    I'm afraid that is something that Microsoft treats as proprietary information. Recent versions of Access included something call Rushmore technology that originated in FoxPro, which gave them a decided performance boost for a desktop database engine. But the internals of Access are pretty well hidden. There is/was a book that dealt specifically with the Jet engine that might shed a bit of light on how some of it works, but I've not seen any documentation on the actual structure of indexes.
    Wendell

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: index structures (XP)

    Hans and Wendell, thank you for your replies. Your responses were more informative than the private Microsoft support bulletin board for Access. I have been designing and using databases for 25 years ( I still have my copy of Access 1.0) but to get teaching credentials for college, I had to go back to school for a masters, my MCSE and MCDBA don't count. If I can return the favor, please let me know.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: index structures (XP)

    As Wendell mentioned, the internal workings of Access are proprietary information. There is an old paper that sheds some light on this: ACC97: Microsoft Jet 3.5 Performance White Paper Available in Download Center. It is for Access 97 / Jet 3.5, but I suppose much of it is valid for later versions too.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: index structures (XP)

    The book I was struggling with is Microsoft Jet Database Engine Programmer's Guide (Microsoft Professional Editions) by Dan Haught, Jim Ferguson and you can see some details about it at Amazon. Our copy seems to be in hiding at the moment, but the Amazon description indicates it does have a section about Rushmore optimization.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •