Re: how to faster 100K records?

I think you should investigate whether you are using indexes appropriately. Depending on how many records you select, you may be better off not using them.

Either way, an explain plan of the query would be nice.

> >Hi, alls
> >
> >In my DB, one table has 100K records.
> >I use one application to insert data to this table only,
> >and in another application i get the data and make
> >the day report of row data.
> >
> >But it is slowly, the SELECT spends me 7 or 8 seconds,
> >i used INDEX with PRIMARY KEY also.
> >
> >How can i make faster ?
> >
> >Thanks in advance.
> >
> >webjb
Received on Tue Oct 23 2001 - 09:00:35 CDT