Thank's I'll get a try using a view, because of large dataset (more than 1 000 000 enreg.) I don't know the time neede by the parametrized view to extract the data needed, the time needed to refresh the view and so on.

I previously use SET FILTER because you've got nothing to do, and if you put your index after your filter it is very fast.

I've got a table which containing different type of people, like prospect customer and so, by this way when I need to create the view, I need to create a big cursor containing more than 200 000 line, I'm afraid about the time the query should take to extract these data.

Roman