MySQL Forums
Forum List  »  General

Re: Speed Enhancements - Indicies
Posted by: Peter Brawley
Date: January 25, 2017 10:42AM

DISTINCT in the query forces the TEMPTABLE algorithm. Without it, the View might perform as well as the underlying query.

How much RAM is available to MySQL?

Options: ReplyQuote


Subject
Written By
Posted
January 19, 2017 05:32PM
Re: Speed Enhancements - Indicies
January 25, 2017 10:42AM


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.