Thanks for all replies! For myself, I prefer 1 either.

来源: 2008-10-10 10:14:06 [旧帖] [给我悄悄话] 本文已被阅读:

But we have a serior developer who like create view better. He created so many different views in DB, some view are very similar. I am tired if this. Everytime when I go through the program code, I need to check view and table which is view based on. We had a little conflict about this. He thought view is easy way. But I disagree.

Thank you all!