On Tue, Jan 07, 2003 at 11:49:05AM +0100, David Bordas wrote:
> > Anybody else who has any idea why the index are not used as they should?
>
> I've got same things with 3.23.xx and select query through a TCP/IP
> connection.
> I don't know why, but you can solve this issue using the USE INDEX synt
> Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
for select queries ...
http://www.mysql.com/doc/en/SELECT.html
Dav
On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote:
> On Saturday 04 January 2003 14:53, harm wrote:
>
> > > Your order by will not use your weg_2 index because, as you stated,
> > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
> > > for the individual c
On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote:
> On Saturday 04 January 2003 14:53, harm wrote:
>
> > > Your order by will not use your weg_2 index because, as you stated,
> > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
> > > for the individual c
On Saturday 04 January 2003 14:53, harm wrote:
> > Your order by will not use your weg_2 index because, as you stated,
> > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
> > for the individual columns as you need
> >
> > try to create a separate index on just the nr column,
