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.