Data Placement Using Filegroups

Optimizing SQL Database Performance

Optimizing Database Performance

Data Placement Using Filegroups

Microsoft® SQL Server™ 2000 allows you to create tables or indexes on a specific filegroup within your database, rather than across all filegroups in a database. By creating a filegroup on a specific disk or RAID (redundant array of independent disks) device, you can control where tables and indexes in your database are physically located. Reasons for placing tables and indexes on specific disks include:

  • Improved query performance.

  • Parallel queries.

See Also

Files and Filegroups