Re: view query is slow

' is only applied when reading from the temporary table. However, I don't see a reason why a view for the above query would be materialized. It should be merged. BR Sergei -- Sergei Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- MySQL General

Re: Composite Index Usage in Joins

') AND trade_year=2012; (year can be changed to quarter or day) BR Sergei -- Sergei Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Is it possible to make this more efficient?

, the query will be only using index, which will give the best possible speed. BR Sergey -- Sergei Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe