NYCPHP Meetup

[Daniel Convissor]

Hi John:

On Sun, Sep 07, 2008 at 02:31:48PM -0400, John Campbell wrote:
> 
> With MySQL the fastest is often:
> Primary(a,b)
> index(b)

I agree.


> And in sometimes you even want:
> Primary(a,b)
> index(a)
> index(b)

The second index of "a" would duplicate the index of "a" in the primary 
key.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409