Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Estimate query time

Estimate query time

From: Steven Salvemini <stevens_at_vsl.com.au>
Date: Fri, 13 Aug 1999 01:26:39 GMT
Message-ID: <37B374DE.14A76EEC@vsl.com.au>


Any ideas of how the estimate how long a query will take to return results,
so the user can determine whether to run the query.

I would expect that the major factors here are that the User can affect the query at runtime, including the ORDER BY columns and the WHERE clause.
Once they set up their query (in Forms 5.0) probably, they want to hit a pre-query button which will estimate how long the query will take if they really run it. Received on Thu Aug 12 1999 - 20:26:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US