As we all know, sql profiles can become invalid if the stats on a table
change, or the layout of a table changes. Has anyone found a way to
identify when a profile is no longer valid, without actually running the
query in question?
I would like to run a daily report to identify any sql profiles that have
become invalid. Sometimes an application provider will implement a change
and a large query that we had fixed suddenly goes crazy again.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'