MySQL Forums
Forum List  »  MyISAM

Re: slow query / table lock
Posted by: Rick James
Date: June 13, 2016 01:57AM

Why is `C` included? It seems to add nothing.

Can't you do COUNT(DISTINCT ProjID) instead of using the extra layer of SELECTs?

Options: ReplyQuote


Subject
Views
Written By
Posted
18558
June 06, 2016 01:55AM
1386
June 06, 2016 02:06AM
1649
June 13, 2016 01:55AM
Re: slow query / table lock
1279
June 13, 2016 01:57AM


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.