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
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
