Guys, Just turn on SQL logging and you will see the answer.
If ARS did what you suggested in the last paragraph, ARS would be a database engine. You can place indexes through ARS (recommended) or directly in the database (not recommended but often done). The effect's the same. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: May-10-11 17:58 To: arslist@ARSLIST.ORG Subject: Re: Does the order of the Set Fields or Push Fields If matter in relation to Index 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"