Michael Scheidell wrote:
> Im still running 2.6.3.. :-)
> explain SELECT mail_text FROM quarantine WHERE
> coalesce(partition_tag,0)=coalesce('200937',0) AND
> ...
> (note that if you coalesce on RHS of equasion, mysql won't use an index.
> second, a in ('38',0) uses a string and a binary, and won't use an index.
I didn't even note this change (as using custom queries), it has been
introduced with 2.6.2. I agree that this has not been the very best
idea.
> explain SELECT mail_text FROM quarantine WHERE partition_tag
> in('0','200938') AND mail_id='WqOfJlW+AG-k' ORDER BY chunk_ind;
> ...
> explain SELECT mail_text FROM quarantine WHERE partition_tag
> in('0','200938') AND mail_id='WqOfJlW+AG-k';
>
> is is true that with this index, you will ALWAYS get it by chunk_ind order?
I would not bet on this ;-) However, while ORDER is usually a very "bad"
command, it should not hurt much in this case, as the resultset is very
small.
Best regards,
Thomas Gelf
--
mail: [email protected]
web: http://thomas.gelf.net/
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
