skip to Main Content

Mysql – how to convert an sql view to table

I have a view and its taking longer time to execute so i need to write simple query to rather than view. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_party_make_subcat_size_map` AS select distinct `m`.`part_name` AS `material_name`,`pt`.`pk_id` AS `pk_id`, `pms`.`fk_party_id` AS…

VIEW QUESTION
Back To Top
Search