OK, so the problem is not in view.

select distinct currency from v_stat_history where sdate between
'1.10.2003' and '3.10.2003' and accid=2 order by row
(9 sec)
select currency from v_stat_history where sdate between '1.10.2003' and
'3.10.2003' and accid=2 order by row
(1.5 sec)

The statstics and PLAN are exactly the same. Why so big time difference?


Riho Ellermaa