I ntroducon to MemSQL SELECT FOR UPDATE ⬤ Procedural Language with support for Procedures, UDF, TVF and ⬤ UDAF Full text search ⬤ Vectorizaon and single instrucon, mulple data (SIMD) ⬤ Operaons on encoded data ⬤ Bloom filter pushdown for hash join ⬤ Local join support (hash, merge, nested loop) ⬤ Distributed join support (broadcast and reshuffle) ⬤ Query opmizaon and Auto Stascs ⬤ Oracle compability extensions ⬤ Adapve query compilaon and execuon ⬤ Just-in-me (JIT) compilaon ⬤ STORAGE Rowstore In-Memory (with compression) ⬤ Rowstore skiplist indexes In-Memory ⬤ Columnstore on Disk ⬤ Columnstore Hash indexes on Disk ⬤ Sharded and Reference tables ⬤ Temporary tables ⬤ DATA TYPES 30