MySQL Forums
Forum List  »  InnoDB

Re: slow query in Inndb
Posted by: Rick James
Date: May 31, 2012 09:40PM

> /*!50001 DROP VIEW IF EXISTS `customersview`*/;
> /*!50001 CREATE TABLE `customersview` (
DROP VIEW + CREATE TABLE ??

I see no "compound" indexes. But I see no need in this query for such.

Options: ReplyQuote


Subject
Views
Written By
Posted
2724
May 29, 2012 09:32AM
1097
May 30, 2012 08:20PM
1111
May 31, 2012 01:23AM
Re: slow query in Inndb
876
May 31, 2012 09:40PM
965
June 01, 2012 10:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.