Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Estimate query time
Yes, exactly, there are a number of factors (including load on the server at
any given time) which affect the query time, and perhaps some experience with
the data and the queries will be the only way to hard code some best guess
rules into the estimate ... if there's not better way to do it.
Frank van Bortel wrote:
> 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 Sun Aug 15 1999 - 20:31:10 CDT