Invisible Indexes – MySQL 8.0

MySQL 8.0 has a rich set of features. One of the feature which interests DBA's more is invisible index What is an index in MySQL ? The indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table … Continue reading Invisible Indexes – MySQL 8.0


Virtual Columns in MySQL and Use cases.

Introduction: MySQL 5.7 introduces a new feature called virtual/generated column. It is called generated column because the data of this column is computed based on a predefined expression or from other columns. What is Virtual Column ? In general virtual columns appear to be normal table columns, but their values are derived rather than being … Continue reading Virtual Columns in MySQL and Use cases.