I tried searching but couldn't find anything, please forgive me if I overlooked something.
I have a query that returns roughly 30 columns, 5 of which are currently derived from in-line functions. They are generally simple functions 3 of them return simple single values for input, 2 of them return a concatenated string from children tables.
I want to set up an optimization run that looks at the query being ran and can tell me if it is most optimal to leave the inline function calls as is, bring them in as inline selects or even as joins.
So far I have tried setting up batch runs as well as singles, and I can't seem to get that sort of evaluation so I am hoping I am just missing something putting in the request. I have at least 3 years ahead of me doing this very sort of analysis and updating on a database that has been migrated and shuffled around since 7.3.4. So I want to maximize the value of the tool as much as possible.