Re: large table help needed

From: Patrick Flahan <flahan_at_southeast.net>
Date: Mon, 4 May 1998 21:01:59 -0400
Message-ID: <6ilqd3$n0n@news.southeast.net>

It would depend on the uniqueness of the three columns. If they are unique or there is very little duplication then an index would probably be a good idea. A good rule of thumb (but not necessarily written in stone) is if you will have to hit 30% or more of the rows, then you should probably do a full table scan.

You might consider just creating the index and testing to see if it improves performance. You could always drop the index later.

Hope this helps.

Patrick Flahan
flahan_at_leading.net

Larry Schenavar wrote in message <6id85d$5l0$1_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 - 20:01:59 CDT