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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"