Yes, that's exactly correct. For Rushmore to kick in, the left side of your condition must match a tag's fields. The tag name is irrelevant.
So in your example, TABLEA must have an index on FGITEM. The tag name does not matter. Fred On Fri, Jun 26, 2015 at 9:08 AM, Philip Borkholder <plbor...@netzero.net> wrote: > Hello all, > > I know that Rushmore tech comes into play when you JOIN tables using > fields that have index tags in their respective tables. > > However, does the tag have to match the name of the actual field being > indexed? > Reason I ask, in an app I support, performance was slow when joining two > tables together on one key field. > > Let's say the field is: > FGITEM > The index tag is just ITEM > > The Join statement had: > > SELECT tableA.*, tableB.descrip FROM tableA INNER JOIN tableB on > tableA.FGITEM = tableB.ITEM > > Once I added a new index TAG to tableA > FGITEM tag FGITEM > > The query ran much faster. > > Does this make sense or am I misunderstanding it? > > Thank you, > Philip Borkholder > Vicksburg, MI > ____________________________________________________________ > Old School Yearbook Pics > View Class Yearbooks Online Free. Search by School & Year. Look Now! > http://thirdpartyoffers.netzero.net/TGL3241/558d7928daeb179283574st04duc > [excessive quoting removed by server] _______________________________________________ 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/CAJCBksqkoPDVeUukKN=+z8PF=Oersnp2=4txnm4y0czeqkd...@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.