February 5, 2008 at 4:14 am
Hi there,
I am busy creating indexes on my tables. One of the tables is about 146 GB in size. I did not have enough space to create the clustered index, so I created another data file within the filegroup and placed it on another drive where the log files reside. The clustered index was created. The query returned results very fast.
I set off anto-growth on the new data file and enabled in again on the original data file. What are the implications if I delete the new file in the filegroup after the index has been created.
Regards
Imke
February 6, 2008 at 3:44 pm
If you created the clustered index in the new file you effecively moved the table to that file. 😉
* Noel
February 6, 2008 at 8:04 pm
You can't remove the file without removing all objects from the file.
February 6, 2008 at 9:58 pm
why you want to move the index back from the log drive if the performance is better?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply