index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travis - 22 Jun 2005 05:41 GMT

Hi ,

If I create a database , it will have a *.mdx and *.log files cater for
that database. If I create a index (clustered or non clustered) is it store
on the mdx files as well or index pages are store on different files ?

Signature

Travis Tan

Reply to this Message

Andrew J. Kelly - 22 Jun 2005 12:53 GMT

I assume you mean the .mdf files? But yes any objects created in the user
database live within the database files.

Signature

Andrew J. Kelly SQL MVP

> Hi ,
>
> If I create a database , it will have a *.mdx and *.log files cater for
> that database. If I create a index (clustered or non clustered) is it
> store
> on the mdx files as well or index pages are store on different files ?

Reply to this Message

Travis - 23 Jun 2005 11:05 GMT

Means that I not able to split out the index pages and the data store in the
database
to different location ?

> I assume you mean the .mdf files? But yes any objects created in the user
> database live within the database files.
[quoted text clipped - 5 lines]
> > store
> > on the mdx files as well or index pages are store on different files ?

Reply to this Message

Andrew J. Kelly - 23 Jun 2005 12:53 GMT

Yes you can do that with filegroups. Create a new filegroup and add one or
more files to that. Then when you create the object you can specify the
filegroup in which it lives. See filegroup in BooksOnLine for more details.

Signature

Andrew J. Kelly SQL MVP

> Means that I not able to split out the index pages and the data store in
> the
[quoted text clipped - 12 lines]
>> > store
>> > on the mdx files as well or index pages are store on different files ?

Reply to this Message