Good Day,
Quick question. I am just trying to confirm if the sql tuning and access advisor runs the sql statement or if all performed in memory. I have a DML statement in question that only has an issue in prod. When reading documents on the tuning advisor it says it hard parses the statement but not much else on details.
My apologizes if this is stated somewhere in the tuning guide but i didnt see it if it is.
Thannks
Dave