For example, if a profile JSON column contains an email address, you can expose it as a generated column and index it for faster lookups. MySQL supports two types: Virtual: calculated when queried and ...