Re: Estimate query time

Steven Salvemini wrote:

> 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.

What about your data distribution? Indexes, optimizer mode, etc will make a difference

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palandijn 3, 7521 PN Enschede        7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
053-4341500