SAP HANA for SQLScript Developers

Coming from a classic RDBMS, why is pre-building secondary indexes, aggregate tables and materialized views usually the wrong instinct on HANA?

Why does looping over rows one-by-one in your program to compute a total defeat the whole point of HANA?

Why should you avoid naming your own table the same as an object in the HANA public schema?

Two SQL statements sit back-to-back in one SQL console tab with no semicolon between them. You press F8. What happens?

You highlight only the first three lines and press F8. Does table NAMES still exist afterward? ``` CREATE TABLE names (id INT); INSERT INTO names VALUES (1); SELECT * FROM names; DROP TABLE names; ```

Why does storing a table by columns make SUM(amount) and single-column filters so much faster than a row store?

You are creating a new business table in HANA. Column store or row store, and why?

Roughly how much faster is main-memory access than an SSD in HANA, and what is the one architectural cost this forces?

If HANA keeps data in RAM and RAM is wiped on power loss, how does a restart recover committed data?

What exactly does a delta merge do, and do you normally trigger it yourself?

Compression costs CPU to pack and unpack. What two tricks keep that cost from slowing live queries in HANA?

In HANA's insert-only column store, what physically happens when you UPDATE one existing row?

What is the difference between main storage and delta storage for a HANA column table?

A column table feels slow and you suspect a bloated delta store. Which system views show how much data sits in delta vs main storage?

In a HANA SQL console, when can you write just NAMES instead of SALES.NAMES to reach a table?

You open a fresh SQL console in HANA Studio and create a table without naming a schema. Where does it land?

You graphically model a calculation view and activate it. Which schema holds the generated runtime object, and what is it?

Your calculation view's design-time file exists but you can't find it in the database catalog. Why not?

In a multitenant (MDC) HANA system, what lives in the system database vs a tenant database, and where do SQL apps connect?

How is HANA tenant isolation fundamentally different from classic SAP client (MANDT) separation?

Match the job to the environment: (a) ABAP + AMDP development, (b) native HANA (HDI) apps, (c) cloud apps.

You need to create a CDS view or an AMDP for an SAP system. Can you do it in the classic SAP GUI?

In SAP Web IDE and Business Application Studio, which tool gives you the catalog + SQL console, and how does its console differ from HANA Studio's?

A tutorial tells you to build a data-centric app on SAP HANA XS (classic). Why is that bad advice today, and what replaces it?

Why can the same HDI container be deployed into several different schemas without editing its objects?

What is dictionary compression in HANA, and which kind of column does it shrink the most?