On Thu, Jul 17, 2014 at 12:43 PM, Richard Kaye <rk...@invaluable.com> wrote:
> Rushmore can use multiple indexes. Always has. > I'm fairly sure the Rushmore technology, once-and-perhaps-still trademarked and patent-pending, was built with the ability to take multiple index bitmaps built from the original B+ trees and merge those values to optimize the records that were ultimately read into the result set. In the end, I think it was this technology (and the couple of really, really smart guys who wrote the code) that resulted in Microsoft purchasing Fox Software and in the coming years introduce similar technologies into the Access engine, ODBC and SQL Server. > Learning how to make indexes that are used in a join and participate in > the where clause is the tough nut to crack. > > -- > Stephen Russell > Hence MS's motivation at hiring the coders and taking out a competitor with the "merger" -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4vlswoalku7ynifxhptyr2hbq8bwv0sytwrekyzda+...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
