On Tue, Feb 25, 2003 at 19:03:40 +1100,
Mark Halliwell <mark(at)transportservices(dot)com(dot)au> wrote:
>
> The majority of records (about 6.8 million) have computer = 8 with sequence
> starting at 2200000 and incrementing by 1.
> There are about 497000 records with computer = 3 with the sequence starting at
> 1 and also incrementing by 1.
> There are only a few records with other computer numbers.
You might get some benefit using a partial index that just covers the
rows where computer = 3.