You are a database administrator

You are a database administrator. A new employee doesn’t understand why, when a query is run against that database, all of the fields are not visible. Explain to the employee what a view is and why they are given one of the table. Describe how indexes are used in creating views and what benefits they may provide.