clustered indexes

Hello,
Does anyone know if a clustered index location dictates
where the actual table data is stored? Can the clustered
index be located on a data file other than the one the
table resides on?
Thanks,
DianeYes it does dictate where the data is stored.
Moving the clustered index to a different FileGroup will move the data
--
HTH
Ryan Waight, MCDBA, MCSE
"Diane" <dfleming@.webmd.com> wrote in message
news:07ec01c3a794$ef088fe0$a501280a@.phx.gbl...
> Hello,
> Does anyone know if a clustered index location dictates
> where the actual table data is stored? Can the clustered
> index be located on a data file other than the one the
> table resides on?
> Thanks,
> Diane|||> Can the clustered
> index be located on a data file other than the one the
> table resides on?
No, essentially, the clustered index IS the data. If you move the clustered
index to a different filegroup, the data will also be on that filegroup.|||Hi,
This might explain a bit further.
Creating a clustered index dictates how the data is to be
stored, and affects behind the scenes pages.
Its sort of like having a manual filing system sorted
alphabetically in a filing cabinet. However it will always
be in order.
It works by ordering the pages in you datafile to come in
a spcific order. So the guys were right, just a bit brief.
If you want further info my email (in reverse) is
ku.oc.elcannip@.nalon.retep
Peter
>--Original Message--
>Hello,
>Does anyone know if a clustered index location dictates
>where the actual table data is stored? Can the clustered
>index be located on a data file other than the one the
>table resides on?
>Thanks,
>Diane
>.
>|||Ever noticed that you can never critique your own work.
Apoligies if it sounded condecending, it wasn't suppost to.
Peter
>--Original Message--
>Hi,
>This might explain a bit further.
>Creating a clustered index dictates how the data is to be
>stored, and affects behind the scenes pages.
>Its sort of like having a manual filing system sorted
>alphabetically in a filing cabinet. However it will
always
>be in order.
>It works by ordering the pages in you datafile to come in
>a spcific order. So the guys were right, just a bit brief.
>If you want further info my email (in reverse) is
>ku.oc.elcannip@.nalon.retep
>Peter
>
>>--Original Message--
>>Hello,
>>Does anyone know if a clustered index location dictates
>>where the actual table data is stored? Can the
clustered
>>index be located on a data file other than the one the
>>table resides on?
>>Thanks,
>>Diane
>>.
>.
>

Clustered and Non-clustered indexes

hi,

how clustered indexes and non-clustered indexes been saved in memory?

non-clustered is a table of a references to the actual table?

and what about clustered indexes?

thanks.

Indexes have nothing to do with memory.

A simple way to explain indexes is just as an index in a book. You have the non-clustered index telling you on what page you can find specific information. The clustered index defines the order in which they are stored, eg. name in a phonebook could be seen as a 'clustered' index because the phone numbers are listed in alphabetic order by name.

I tried to give a very simple explanation but there are a lot of resources explaining indexes on the internet. Choosing the rights indexes is an art so try to learn as much as possible about it.

Hth