>it is persistent ?
>Every update/delete/insert on table refresh view index ?

(UniversalThread is misbehaving and logging me out whenever I try to update, so I add this as a new reply)

It is not persistent. You don't need a view for this (I wouldn't prefer a view to say otherwise). As Hilmar noted already, you can have an index based on an expression in your tables.