INFORMATION_SCHEMA and Data Dictionary Integration • INNODB_COLUMNS • FILES • INNODB_DATAFILES • INNODB_FIELDS • INNODB_FOREIGN • INNODB_FOREIGN_COLS • INNODB_INDEXES • INNODB_TABLES • INNODB_TABLESPACES • INNODB_TABLESPACES_BRIEF • KEY_COLUMN_USAGE • INNODB_TABLESTATS • KEYWORDS • PARAMETERS • PARTITIONS • REFERENTIAL_CONSTRAINTS • RESOURCE_GROUPS • ROUTINES • SCHEMATA • STATISTICS • ST_GEOMETRY_COLUMNS • ST_SPATIAL_REFERENCE_SYSTEMS • TABLES • TABLE_CONSTRAINTS • TRIGGERS • VIEWS • VIEW_ROUTINE_USAGE • VIEW_TABLE_USAGE Queries on those tables are now more efficient because they obtain information from data dictionary tables rather than by other, slower means. In particular, for each  INFORMATION_SCHEMA  table that is a view on data dictionary tables: 2993