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
精彩评论