> - 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]
