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

With proper indices, you should be fine, even with a growing amount of
records.

Mind you, creating an index on a table needs exclusive access to the
table, which can take some time on a huge table. A larger temporarily
page cache for index creation might help to decrease execution time.




--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!