Re: Performance

From: <samger_at_my-deja.com>
Date: Sat, 04 Sep 1999 00:12:18 GMT
Message-ID: <7qpo4q$938$1@nnrp1.deja.com>

In article <XNbPN3MRi0DZxczaUPGsmwr1qQRi_at_4ax.com>, tkyte_at_us.oracle.com wrote:

> >(select * from tablename where name='something' and logtime between
> >'27-jul-99' and '28-jul-99') returns about 6000 records. The
tablestructure
> >is simple:
> > logtime date;
> > name varchar2;
> > value number;
> >
> >Every minute 50 records are added to the database, and she holds
about 1.5

if the index is "logtime name" then you should us it in the same order for your where clause
try "explain plan for ...." / select * from plan_table
analyze the table and index often as it heavly grows
try instat of between > < (logtime > to_date('27-JUL-99','DD-MON-YY') and logtime < to_date ....) that is faster on my database (8.0.5.*)

some feedback would be nice ..

Alexander Venzke
Munich - Germany

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 19:12:18 CDT