June 19, 2013

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

…selected at the time of view creation and may not …customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews....add_expr(@mvid,'GROUP','DATE_FORMAT(order_date,”%Y%m”)’,'sale_…which is an auto_increment BIGINT surrogate key for the … they are out-of-date and must be refreshed: mysql> …