Search code examples
indexingsap-ase

Indexed Views in Sybase

Is it possible to create indices on views in Sybase (> ASE 12.5)?

Solution

  • 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