Gary Benade wrote:

> I have a table with approx 1 million customers, and each customer has a
> value based on a weighted scale. Most of the time I want to work with the
> top 80000 customers for distribution reasons.
>

I strongly suggest that you follow the relational model and keep data as
data rather than position, order, or other artifacts. Make your
selection based on the scale.

Regards,


Ann