Everyone, Gary is correct. Whenever we query the DB, we create an SQL command with the query you entered appropriately translated to the underlying tables and issue it to the database. The DB engine optimizer does all the work of figuring out what index to use.
The DB optimizers have become very good. The order of the fields in the command are not in general important. It will figure out what is the best index to use regardless of order. I qualify "in general" as someone will always be able to come up with some esoteric example for where order does matter. BUT, that would be a very obscure situation with an extremely complex qualification with special characteristics. You should not have to worry about this topic when constructing your qualifiers. Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Tuesday, May 10, 2011 8:58 AM To: [email protected] 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:[email protected]] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, May 10, 2011 10:48 AM To: [email protected] 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 [email protected] 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"
