Re: SV: index troubles

2001-04-30 Thread Thalis A. Kalfigopoulos
On Mon, 30 Apr 2001, Wix,Christian XCW wrote: > But why doesn't this work then: > select name, tottid, distance, min(mintid) from loeb group by distance; > (tottid seems to be random) > > mysql> explain select name, tottid, distance, min(mintid) from loeb group by > distance; > +---+--+-

SV: index troubles

2001-04-30 Thread Wix,Christian XCW
But why doesn't this work then: select name, tottid, distance, min(mintid) from loeb group by distance; (tottid seems to be random) mysql> explain select name, tottid, distance, min(mintid) from loeb group by distance; +---+--+---+--+-+--+--+---+ | tabl