What database system do you use?

Also, you need to give a real query since in some systems, you can explicitly specify what algorithms is used to create the view. The performance difference can be significant.