It depends on your data. If you don't have too much data, then you can just index one field (note that the request ID - field 1 - is always indexed by default). If you have a lot of data, then it can be beneficial to index more fields. Basically, the way it works is that if you have one field indexed, it will search based on that index, and then scan all the results to find items that match the rest of the qualification. If you have more fields indexed, then it can go more directly to the item you're searching for, which is more efficient.
Note that for this to be effective, you need a single index that includes all the fields rather than having a separate index on each of the fields. Otherwise, the database will simply choose one of the indexes (whichever one it thinks will be most efficient) and use that, ignoring the others. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Tuesday, April 13, 2010 2:09 PM To: arslist@ARSLIST.ORG Subject: Join Forms ** The BMC Documentation says "For optimal performance, use indexed fields in the join criteria." If I use a qualification for the Join Criteria of ( 'Survey Number' = $Survey Number$) AND ( 'Network ID' = $Network ID$) AND ( 'TEIS Request ID' = $Request ID$), for optimal performance should each of these fields be indexed on each form? Or would it be OK for just one of these fields on each form? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
