for data and index : few big files or many small files ?
Hello,I have to create a new database on HP_UX .
ON the machine, for the datafiles, i have 7 file systems (mirrored) . About 60 Go each.
I suppose that datas will be 50 Go at the end of 2013 and the indexes will be 70 Go
Is it better to dispatch datas in many files of 10 Go Max ( the goal would be to be able to move the file easily in case of necessity )
or to limitate the number of files with 2 files of 25 Go ?
Thank you for your advices.
ON the machine, for the datafiles, i have 7 file systems (mirrored) . About 60 Go each.
I suppose that datas will be 50 Go at the end of 2013 and the indexes will be 70 Go
Is it better to dispatch datas in many files of 10 Go Max ( the goal would be to be able to move the file easily in case of necessity )
or to limitate the number of files with 2 files of 25 Go ?
Thank you for your advices.
0