I have the following problem and I would like to know your opinion:
database size= 200 G (data warehouse)
datafiles : primary(50%)
My question is:
- what is the best to leave on primary datafile.Is it too big ??
- how is the performance if a SQL runs on 1 datafile or many datafiles at the same time.
- is it better to have big tables with the indexes separated on different datafiles?
- and if yes, how can I design it to increase the performance?