Hi,
>how can I do it with view?
As Sergey said, you can index the view. However, this only works when row buffering is active. With table buffering, you first need to commit/revert any changes and switch to row buffering. After creating the index you can switch back to table buffering.
--
Christof