I'm not sure about the order of the RUN IF but you can try running the workflow with SQL logging on to get that actual query. Then run the query through a SQL tool (like SQL Navigator) and look at the execution path. That will show you the table scans and how the query is actually working. Once you get the query running like you like it, you can have your dba's (or you, if are lucky enough to have the rights) optimize the execution and it will save the most optimized execution to the db. That will ensure that the workflow always runs in the most efficient manner possible.
________________________________________________________________________ _______ 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"
