You should index the table begining with the column that is holding most
different values.
The indexing can do as much as 15000% in speedincrease.
Regards
/Joachim
Larry Schenavar wrote in message <6id84d$bj3$2_at_news1.infoave.net>...
>I have a 4 column table with 8 million rows. The key is 3 of the
>columns(one of them is a date). The table is very slow to query. Will
>creating an index on those three columns help? any other thoughts.
>
>
>
>--
>==============================
>Larry Schenavar
>Infrastructure Specialist /DB
>Electronic Data Systems, Inc
>
>Email: schenavar_at_northstate.net
>==============================
>
>
Received on Mon May 04 1998 - 07:36:03 CDT
