Hi,

Any word of advice on if each table and index to be placed in its own
physical file versus many tables share the physical file. On the average
customer installation of our product could have 30+ fact tables and 50+
indexes. These fact tables grouped by datasource type, i.e, each type of data
source populates respective set of tables and indexes.

Current thinking is to store each data source type in to two
filegroups(tablespaces - we also support Oracle), one for the table data and
the other for index. Within the filegroup, should each table be in a separate
physical file. I see that if they are in separate file, file corruption etc.
would affect only one table. But at the same time, the number of files will
keep increasing.

Appreciate any help on this.

Thanks,
Latha