composer require mage/product-view
All the tables(ViewTable, MView, JSON) will be create on setup:upgrade
You can also run it with the command bin/magento pview:run, which will populate the table with the data.
bin/magento pview:run
Command Output:
By running this code populateProductJsonTableFromView($changeLog = false) with the true parameter, you are generating data only for change log data
Tables will be generated:
- catalog_product_view : it is a view, not a table. Runs direct SQL to the core magento tables. Update mechanism not required however, has performace of the raw queries
- catalog_product_view_MVIEW : materialized view table from the view table. An update mechanism is required
- product_json : table with the denormilised json attribute data in the data field. An update mechanism is also required
