Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed with big table
Larry Schenavar wrote:
>
> Hello,
>
> I have a table with 4 columns. It contains 8 million records and the key is
> three of the columns. It is very slow to access. Does anyone have any
> recommendation to increase the performance. Is indexing the three columns a
> waste?
>
> ==============================
> Larry Schenavar
> Infrastructure Specialist /DB
> Electronic Data Systems, Inc
>
> Email: schenavar_at_northstate.net
> ==============================
If the PK is 3 of the 4 columns as you say, you already have an index.
Question the date. Is it really required as part of key? I suspect
that for each query asking for or using the date column, there is
date conversion going on for each row just to build the result set.
Consider a date_id instead. If not doing date calcs, make CHAR?
may help.
good luck
bobh
Received on Sat May 02 1998 - 22:07:15 CDT