Re: Working with large datasets

""Toby Hart Dyke"" <toby@hartdyke.com> wrote in message news:00da01cc8768$ca9e9200$5fdbb600$@hartdyke.com... > > It sounds as though you don't have an index on the right field. 8 million > records should be no problem if you have the right indexes applied, and > you're not trying to do anything too complicated. > > Toby I doubt that the State field is a primary index, or that it would be used as one, which means that it could be a secondary one. If it is - that would be a pretty long record itself and could be the problem therein. With virtually all the records tied to one secondary key it is mostly a worthless secondary index. I'd try removing it and seeing what happens.