• Definitely NOT. I would recommend to create more files per each group and place on the different disks (2 to 3 file on each disk), this will definitely improve the performance because when reading the table a separate thread will be created for each file to access the table data. If your table is heavily accessed table like orderdetail or orderhistory I would recommend to create table in one group and tables index in another file group and place on different disks. As you know log file is more write intensive, place it on a separate disk

    Shas3