CODEWITHSUNDEEP
indexingsap-ase
oninea
oninea

Reputation: 1453

Indexed Views in Sybase

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

Upvotes: 2

Views: 7537

Answers (2)

Gopal Sanodiya
Gopal Sanodiya

Reputation: 204

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

Upvotes: 5

Burcin
Burcin

Reputation: 985

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

Upvotes: -1

Related Questions