Wednesday, 25 May 2011

Create Separate File Group to create Indexing

Here are the steps to create separate file group for indexing on any table. We can use different file location (on hard disk) for file group to avoid the problem of space on hard disk.

step 1: 
Right Click Database -> Properties

Step 2: 
Click on file groups option - > Add  -> Enter some file name

Step 3:

Click on Files -> Add -> Enter some Database file name and Select FileGroup created in above Step-2

Step 4: 
Click Ok Or Click on Script on the top to create SQL Script and then run through that Script.
It will take some time.

Step 5 : Index Creation:
Go to Database - > Indexes - > Create New Index:
Enter some index name - > Click on Add -> select the field name




Step 6:
Click on Storage from left side.
Next to filegroup option select the filegroup created in step 2




Step 6:
Click Ok Or click on Script on the top to generate the Script and then run that script.

It will take some time to finish indexing depending on the size of database.





No comments:

Post a Comment