how to effectively modify index

Posted by daedlus on Stack Overflow See other posts from Stack Overflow or by daedlus
Published on 2010-04-20T17:28:13Z Indexed on 2010/04/20 17:33 UTC
Read the original article Hit count: 371

Filed under:
|
|
|
|

Hej everyone,

problem : I am looking for right way to convert an index from clustered to non-clustered

Description : I have a table as below in sybase db:

dbo.UserLog

Id | UserId |time | ....

This is hash partitioned using UserId.

Currently it has 2 indexes

UserId : non-clustered

time: clustered

This table has about 20 million records.

I now want to make UserId as clustered index and time as non-clustered index.

is it correct to user alter index to change from clustered to non-clustered or do i drop index and recreate. does the fact that userId is used in hash partitioning have any implications to this?

To me alter seems way to go but I have not yet tried this.

© Stack Overflow or respective owner

Related posts about sybase

Related posts about alter