Thank you All for your suggestions.
If there are no performance difference between a view and querying from a fact table then What are the advantages of creating views in database?
Thanks in Advance
I rarely use views, but when I do, its usually for the reason to encapsulate situations that are often used. I.E. The join between Sales Order Header and Sales Order Detail.
Or, power users doing select queries to make it easier for them.
But again, its pretty rare.
Obviously I dont buy into the old DBA theory that EVERYONE must access a DB through a view, circa 1995.