Indexing to MySQL may be required for two primary reasons, to allow report generation from external tools such as Microsoft PowerBI or to improve the speed of data loading in Lists.

To setup MySQL Indexing open the form setting by following the steps here.

Enable Indexing by setting 'Index data in database' as checked and save the form setting as shown below.


Once the form is saved tables are automatically created in the database and any existing data is automatically indexed. Any future records that are created shall also be indexed.

Indexed data is spread over several tables and normalised, the list of tables shall be displayed in the Tables Created field, the primary table for the form shall have the same name as the form design name, each multi-value field, repeating section or grid shall also have its own table for capturing data.