开发者

Indexed Views in Sybase

开发者 https://www.devze.com 2023-01-14 21:40 出处:网络
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

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

精彩评论

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