sybase 关于聚集索引修改的问题

ljb222521

聚集索引和非聚集索引有很大的区别，查询速度上有很大的差别，sybase允许一个表有一个聚集索引，但是它默认的是主键为聚集索引，我想问一下，如果要把其他列定义为聚集索引，应该怎么办？谢谢！

chenfeng825

1> create table tab(id int,name varchar(30),constraint pk primary key(id))
2> go
1> create clustered index idx on tab(name)
2> go
Msg 1902, Level 16, State 2:
Server 'SYB_SRV', Line 1:
Cannot create more than one clustered index on table 'tab'.  Drop the existing clustered index 'pk' before creating
another
1> alter table tab drop constraint pk
2> go
1> create unique index pk on tab(id)
2> go
1> create clustered index idx on tab(name)
2> go
Non-clustered index (index id = 2) is being rebuilt.