Has anyone ever seen a reliable way to determine query cost/estimated time to complete a query from a client application?
Looking at set showplan_all, I see some possibilities but am left to guess what the total query cost/time really is, could be time in seconds, could be...?
In this circumstance I would like to evaluate a sql statement at run time (e.g. user hits submit button on a web page) and determine whether the query should be attempted or submitted asynchronously and the results returned via email or other method.
Setting a server query cost limit doesn't solve the problem - queries have to run not get thrown out for exceeding cost limit.
Thanks,
Joe