Is it possible to create indices on views in Sybase (> ASE 12.5)?
A:
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
Burçin Yazıcı
2010-09-03 07:03:36
Burcin, thanks for you example. I tried the same thing on ASE 12.5. Would you know if this is possible with ASE > version 12.5?
oninea
2010-09-03 07:45:31
index data is stored in the pages related with data pages. 'views' are dynamic shortcuts therefore it is not possible logically.
Burçin Yazıcı
2010-09-03 08:14:36