Index MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Index
  4. Creating an Index on a Filegroup
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]