Hello Listers, We are looking at ways to make workflow (Filters/Active links) queries to the database quicker. We have been working on optimizing our indexes but a question came up that really stumped me. The question was "Does the order in a qualification matter?" I am hoping someone wiser than me on this list could provide some insight.
Say you have three fields, as a single index, and you are referencing those three fields in a Run If, Set Fields If, or Push Fields If qualification. For this question let say you have 3 indexed fields in the qualification along with 2 non-indexed fields. Should those indexed fields always start the qualification statements first or does it matter where they are placed in the qualification? The question gets down to: If 2 non-indexed fields start the qualification and the 3 indexed fields follow, will this cause a slower response from the database, as opposed to using the 3 indexed fields first and then the 2 non-indexed field last? 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"
<<attachment: Picture (Device Independent Bitmap) 1.jpg>>
