creating and moving clustered index

[timc]

have a 3rd party app (can't change) which has some bad sql. I have a table that is used in the sql which if I put a clustered (I had an index on the fields in the sql but it would ignore and table scan) will use and stop doing table scan. this is a million row table that is growing. the data going in is pretty mich insert only. I have a separate array and file group which I have moved indexes to last year. 2 questions

1. If I would make a clustered index on the separate RAID and file group, doesn't the table need to go with it. I thought the clustered index and table had to be on same File Group

2. If I do this anyone see any issues with moving this table and index on this file group

[rmiao]

1. Yes.

2. Should be ok.

[MohammedU]

Keeping in mind that moving the table is offline operation.