MySQL Forums
Forum List  »  Newbie

distinct vs. group by
Posted by: Henrik Genssen
Date: August 23, 2010 11:45AM

Hi,

can someone please clarify, if there is a difference in using one or the other by using myisam like they did here for Oracle?
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:32961403234212

Is it a mythos?
How does it affect temp tables/files?
Can or should they be omitted?
Does switching to an other db file system have the same effect (innodb)?

regards

Hinnack

Options: ReplyQuote


Subject
Written By
Posted
distinct vs. group by
August 23, 2010 11:45AM
August 24, 2010 11:52PM


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.