Re: Query optimization for a table with half million rows

If you have Oracle 8.0.XXXX try creating a partitioned table with a partitioned index.

I hope this solve your problem.

Bye.

Javier Morales

Kevin Kirkpatrick wrote:

> I have a table right now that has slightly over half a million rows, and
> will soon have about 1.2 million rows. The rows consist of and id
> number (not unique) followed by data that cooresponds to that id
> number. If I query based on an id number it is possible for 100 to
> potentially 50,000 rows to pop up. The problem is that it takes a good
> amount of time for the query to execute when it returns a large amount
> of rows. It seems to be fairly quick when the result is small. Is
> there anyways that I can speed this up for the large results? I am
> using just the standard SELECT * FROM TABLENAME WHERE ID=VARIABLENAME.
> Any suggestions would be highly appreciated. Thanks
>
> Kevin
>
Received on Thu Sep 24 1998 - 10:48:53 CDT