Slide 17
Slide 17 text
PRESENTATION TITLE ON ONE LINE
AND ON TWO LINES
First and last name
Position, company
▪ CREATE TABLE base_table (
p int,
c int,
v1 int,
v2 int,
PRIMARY KEY (p, c)
);
▪ UPDATE TABLE base_table SET v2 = 9
WHERE p = 0 AND c = 1
Read-before-write
17
▪ CREATE MATERIALIZED VIEW
view_table AS
SELECT * FROM base_table
WHERE v1 IS NOT NULL
PRIMARY KEY(v1, p, c, v2);
▪ Update (8, 0, 1, 9)