If your are using the fourth field's value most of the time,
then you better add that field to the index.
In oracle 8 you have an index only table, which can suit your needs.
Larry Schenavar wrote in message <6id84b$bj3$1_at_news1.infoave.net>...
>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
>==============================
>
>
Received on Mon May 04 1998 - 11:25:17 CDT
