Separate indexes from tables

[bobbo]

If I install a new disk on my server, is it possible to move the indexes for a particular table to the new disk.
what I'm after here is performance improvement so if I can identify a table that is heavily hit and physically separate the indexes from the table to enable both to be read at the same time.

Also, if this is possible, how does it compare to other options like moving tempdb to it's own disk

Note : my server has plenty of RAM, etc. The buffer cache hit ratio averages at about 99%

[rmiao]

Yes, you can. Just create a new filegroup on new disk, you can move non clustered indexes to that filegroup.

[bobbo]

thanks,

can you point me to a good article on moving tempdb in SQL Server 2000

[rmiao]

Check kb article 'Moving SQL Server databases to a new location with Detach/Attach', it should be on its own array.