Speaker(s): Amit Bhattacharya (Bangalore)

Abstract:
Get in depth knowledge of implementation and usage of Generated/Virtual Columns in MySQL(a new feature in MySQL 5.7). * Generated Columns can be used as materialized storage for most used expressions.* It provides a way for supporting indexes for joins with non-relational data(JSON data type) and it gives an option to either store the value of expression or let it be calculated on the fly when the record is read from the table. * Last but not the least we support indexing on these column.

(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))

Event Page: http://2017.fossasia.org

Produced by Engineers.SG

Help us caption & translate this video!

http://amara.org/v/5L1b/