Day 8 — SAP HANA Views

What is a View in SAP HANA? Why do we use it?

A View is a virtual table created from one or more database tables. It does not store data physically; instead, it displays data from existing tables. 1. What is a View? a. It is a virtual table. b. Created using one or more tables. c. Does not store data physically. d. Displays the latest data from the source tables. e. Accessed using SQL queries. 2. Why Do We Use Views? a. Simplifies complex SQL queries. b. Combines data from multiple tables. c. Improves data security. d. Makes reporting easier. e. Reduces duplicate SQL code. 3. Advantages of Views a. Easy to maintain. b. Faster report development. c. Shows only required data. d. Improves data security. e. Reduces query complexity.

• A Sales Manager needs Customer Name, Order Number, and Order Value. • Instead of joining multiple tables every time, • A View is created using CUSTOMER and SALES_ORDER tables. • The manager directly accesses the View to generate reports.

1. What is a View? 2. Does a View store data physically? 3. Why do we use Views? 4. What are the advantages of Views? 5. Give a real-time example of a View.