Re: Estimate query time

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 13 Aug 1999 15:25:45 -0700
Message-ID: <37B49B69.A4B0FAF7@vnl.nl>

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 Received on Fri Aug 13 1999 - 17:25:45 CDT