View optimization

[Richard Ollier <r.ollier@xxxxxxxxxxxxx>]

Hello,

I was wondering it there was a way to optimize a view.
If my view contains 20 LEFT joins, my guessing is that each time I will 
make a select on it, the view will be completely recalculated. Is there 
a way to have it up and running all the time like a table would be ?

Any advice here is more than welcome !

Thanks
Richard