Re: Query execution for intervals
From: <frebe73_at_gmail.com>
Date: 9 Feb 2006 04:44:46 -0800
Message-ID: <1139489086.727572.103070_at_g44g2000cwa.googlegroups.com>
Date: 9 Feb 2006 04:44:46 -0800
Message-ID: <1139489086.727572.103070_at_g44g2000cwa.googlegroups.com>
> > Oracle is the RDBMS. I am using standard index (create index....)
> create index can create several kinds of indices.
In what way should I create the indexes to make the best possible
search?
> > 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.
> Have you done an experiment to collect some data about the actual response
> time for running the query ?
No, I was hoping to get a qualified answer at this forum.
Best regards,
Fredrik
Received on Thu Feb 09 2006 - 13:44:46 CET