Hi All,
Currently a question was asked to me in an interview about Views that what are it's advantages, my reply was:
1. That it provides kind of encapsulation for table objects in case we want to share some data to some third party.
2. It hides all the complexity of data from programmer who actually want to retrieve data.
But interviewer says there are few more:
1. Like it gives better performance than query.
But didn't find any logic in accordance to this. Kindly help in clearing this confusion.