| |

VerySource

 Forgot password?
 Register
Search
View: 723|Reply: 2

Is it possible to put the indexes in a table that has been created and run for a period of time into another file group?

[Copy link]

4

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-11-11 09:00:02
| Show all posts |Read mode
I did not succeed in this experiment
Server: message 622, level 16, state 3
No files are assigned to the file group'secend'. You can only add files
The table, index and text, ntext and image columns are populated on this file group.

The secend above is added in the database properties

But creating a new table will work again.

thanks
Reply

Use magic Report

0

Threads

48

Posts

30.00

Credits

Newbie

Rank: 1

Credits
30.00

 China

Post time: 2020-11-11 15:30:01
| Show all posts
delete index then create index
Reply

Use magic Report

0

Threads

16

Posts

10.00

Credits

Newbie

Rank: 1

Credits
10.00

 China

Post time: 2020-11-11 16:45:01
| Show all posts
The approach upstairs is correct.
By the way, if it is a clustered index, it cannot be separated from the Table, they can only exist in the same file group. If it is a non-clustered index, there is no problem.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list