June 19, 2013

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 Comments

…php convert.php demo < sales.sql CALL flexviews.create('demo', 'dashboard_customer_sales', 'INCREMENTAL'); SET @mvid := LAST_INSERT…alias: ol mview_join_condition: USING (order_id) mview_join_order: 999 3 rows in set (…ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql…

Filed Under: Insight for DBAs, MySQL