clustered index on its own segment?

I am trying to increase the performance of a small database with a table
that occupies 60% of the disk space.

Aside from archiving some data , I am thinking of moving the only index now
-- the clustered index -- on to its own segment in an effort to speed up
performance. I am sure if:

1) a clustered index can be on a separate segment since the data, I think,
would move with it? Is hat correct?

2) If it is corect, should I do that? How ?

Thanks.

David Spaisman

[Greg]

look in Books on line, for "Create Index",
it has optional parameter &#34;On <segment>&#34; that allows you to create index
on separate segment

use sp_addsegment to create segments
also, look for information about &#39;sp_placeobject&#39;

On 3/3/99 8:44:54 PM, wrote:
> I am trying to increase the performance of a small database with a table
>
that occupies 60% of the disk space.

Aside from archiving some data ,
> I am thinking of moving the only index now
-- the clustered index -- on
> to its own segment in an effort to speed up
performance. I am sure
> if:

1) a clustered index can be on a separate
> segment since the data, I think,
would move with it?
> Is hat correct?

2) If it is corect, should I do
> that? How ?

Thanks.

David
> Spaisman