Tim Ward
Brett Ward Limited - www.brettward.co.uk
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 2002 11:17
> To: Tim Ward
> Subject: Re: RE: SELECT performance
>
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire
> text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has
> something to do
> with MySQL. Just typing the word MySQL once will be
> sufficient, for example.
>
> You have written the following:
>
> > Is there any thing that I am not seeing? I there any way to
> > change this
> > behaviour?
>
> Adding an index on (a,b), rather than just having one on a,
> should change
> the behaviour.
>
> Tim Ward
> Brett Ward Limited - www.brettward.co.uk
>
>
>
> -------------------------------------------------------
> On August 5th ip.access will be moving to:
>
> CPC1 Telephone: +44 (0) 1223 219000
> Capital Park Fax: +44 (0) 1223 219099
> Fulbourn
> Cambridge CB1 5XE
> United Kingdom
> -------------------------------------------------------
> This e-mail and the information it contains are
> confidential and may be privileged. If you have
> received this e-mail in error please notify us
> immediately. You should not copy it for any purpose, or
> disclose its contents to any other person. All emails
> to and from ip.access may be monitored and stored for
> audit and other legal reasons.
> -------------------------------------------------------
>
>
>
-------------------------------------------------------
On August 5th ip.access will be moving to:
CPC1 Telephone: +44 (0) 1223 219000
Capital Park Fax: +44 (0) 1223 219099
Fulbourn
Cambridge CB1 5XE
United Kingdom
-------------------------------------------------------
This e-mail and the information it contains are
confidential and may be privileged. If you have
received this e-mail in error please notify us
immediately. You should not copy it for any purpose, or
disclose its contents to any other person. All emails
to and from ip.access may be monitored and stored for
audit and other legal reasons.
-------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
