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.
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