Creating an Index on a Filegroup : CREATE INDEX « Index « SQL Server / T-SQL Tutorial

ALTER DATABASE YourDatabase
ADD FILEGROUP FG2
GO

ALTER DATABASE YourDatabase
ADD FILE
( NAME = AW2,
FILENAME = 'c:\db.ndf',
SIZE = 1MB
)
TO FILEGROUP FG2
GO

CREATE INDEX NI_IndexName ON
TableName (ColumnName)
ON [FG2]

17.1.CREATE INDEX
	17.1.1.	The basic syntax of the CREATE INDEX statement
	17.1.2.	Create an index for the column emp_no of the table employee.
	17.1.3.	Enforce Uniqueness on Non-Key Columns
	17.1.4.	Create a Composite Index
	17.1.5.	Define Index Column Sort Direction
	17.1.6.	Disable an Index
	17.1.7.	Change an Existing Index with DROP_EXISTING
	17.1.8.	Intermediate Index Creation in Tempdb
	17.1.9.	Control Parallel Plan Execution for Index Creation
	17.1.10.	Allow User Table Access During Index Creation
	17.1.11.	Using an Index INCLUDE
	17.1.12.	Use PAD_INDEX and FILLFACTOR
	17.1.13.	Disable page locks. Table and row locks can still be used.
	17.1.14.	Disable page and row locks. Only table locks can be used.
	17.1.15.	Allow page and row locks
	17.1.16.	Creating an Index on a Filegroup
	17.1.17.	Indexing a View
	17.1.18.	A statement that creates a nonclustered index based on two columns