Chris good question. I had always assumed that the ARSystem just took the query, then formatted it in TSQL and sent it off to the database engine. If this is the case, then the database engine will follow the query optimizer settings to follow the index trail.
If, however, the ARSystem actually does the querying itself (which I had always assumed it hadn't) then that would be a good question for Mr. Mueller. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, May 10, 2011 10:48 AM To: arslist@arslist.org Subject: Does the order of the Set Fields or Push Fields If matter in relation to Index Need some feedback from all your database SQL experts out there. We have been having an ongoing discussion regarding the use of Indexed fields within a Set Field If Action and/or a Push fields If Action qualification. Here is what we are looking at. You have a form with three indexes, Inx1, Inx2, and Inx3. Either the Set Field If Action or Push fields If Action qualification is set up in this format. Form Field 1 = Database Field 1 AND Form Field 2 = Database Field Inx3 AND Form Field 3 = Database Field Inx1 AND Form Field 4 = Database Field Inx2 The question is does AR Server evaluate the qualification as whole and determine if any of the fields are indexed first and then pull a subset of records to find the last value "Form Field 1 = Database Field 1" or does it build the records sets in the order the Set Field If Action or Push fields If Action qualification is designed. Meaning it first pulls those records in the "Form Field 1 = Database Field 1", then Form Field 2 = Database Field Inx3, and so forth. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com<http://www.hp.com/> Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"