hi,

is it possible to create an index to a view?

Our environment is a DB2 on AS/400 V5R3

Thanks in advance.

according the help this is not possible - doesn not seems logic either.
why would you create an index just for one view
if the index is on a table - all views can use it - because a query is always run against a table and not a view
Best Regards, Guy Przytula

the view contains an union statement...

so i see no option to set an order by clause
to the view... thats the reason for an index

any idea to set an order by clause to a view?

select * from view order by xxx
Guy Przytula

select * from view order by xxx ... ;-))

i need the order by statement at the creation of the view...

the select... order by... "great idea" ...

thanks for your help...