Re: Query execution for intervals
Date: Thu, 9 Feb 2006 13:59:04 +0200
Message-ID: <dsfaqa$q68$1_at_emma.aioe.org>
<frebe73_at_gmail.com> wrote in message
news:1139480867.427295.299120_at_f14g2000cwb.googlegroups.com...
> > I really don't see how how there can be a short answer to this question.
> Ok, give me the long answer...
>
> > Don't know much about current products but assuming the indexes you
> > mention are dense ones 'on top' of a row-based store
> Oracle is the RDBMS. I am using standard index (create index....)
create index can create several kinds of indices.
> The meaning of linear is if the response time of the query execution
> can be calculated by the formula: time = k * n, where n is the total
> number of records.
Even if the DBMS only use one index, the time is not linear.
> > It might help if we knew more about all the queries in the app
> I already provided the query.
Have you done an experiment to collect some data about the actual response time for running the query ? Received on Thu Feb 09 2006 - 12:59:04 CET