Post the DDL for the tables and indexes. Can't really tell what the issue is based solely on your post. Also, post the DDL for the database as well so we can see the file groups associated with the database.
When you move a clustered index to different filegroup,that means the table is moved .sp_help 'tablename' will show you that the data is located on secondary filegroup.
Moving clustered index means moving the Table.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply