Objects can be created on filegroups. a filegroups is a named collection of database file. to accomplish what you want, create a filegroup and then create some addition database files in the c:\indexfiles folder and make the files part of the filegroup.

When you create the index, use the ON clause to put the index on the filegroup that you created.

Becareful with clustered index. remember that it is the table.

-Mike

>I have a basic question about tables and indexes. After I install SQL Server and set up the location of the user databases to be on a specific drive how would I set the location of the indexes for the user tables if I want them on another drive? For example:
>
> I have the tables on e:\usertables
>
> and I want the indexes to be on: c:\indexfiles
>
>Thanks in advance
>Kelly