> - How many distinct contact ids do you expect
>

around 100 000

> - How does your query pattern look like?
>

select xxx from table BIGTABLE where
contactID=xxx and
fialdA=xxx and
....
fieldn=xxx
order by fieldw

>
> Because of latter, is contact id the only criteria for filtering rows or
> are there more (e.g. date/time, product etc ... information)?
>

no, much more criterias than just contact ID

> You always can work with an archive and "most recent" table (maintained
> by triggers), in case of performance slow down due to increasing data
> volume. This, possibly is in relationship with your query pattern as well.
>

i already do like this and this gave me 80 000 000 reccords table :(


thanks for all Thomas




[Non-text portions of this message have been removed]