Data Files | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data Files

Hi All,
How would i place the tables that are heavily used into different data files of an online data base?
Will it improve the query performance
Regards Atul A Sathe
Hi Atul,
If u can place those heavy tables in different data files then ofcourse it will improve the performance.
U can do this thru EM or by creating index in secondary filegroup.
check this similar topic
Yes u can Check these says
If you know for sure that a very large table in your database will always be accessed sequentially, consider putting this table in its own filegroup, and then locating it on a disk array by itself. Be sure you don’t put more than one table in the filegroup and that no other files exist on that disk array. By doing this, you can take advantage of the disk array’s ability to operate sequentially to retrieve the data. Sequential access is always faster than random access.