开发者

Indexed Views in Sybase

Is it possible to create indices on views in Sybase (> ASE 开发者_高级运维12.5)?


You can't create index on views becauce view is not a physical entitity. its just a view defination(sql query) execute when view is called.

You can create index on base tables which can be accessed while view is called


I tried and got this error:

create view zzz_xyz as select * from sample_table
go
create index xxxxx on zzz_xyz  (sample_column)
go
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜