On Tue, Jan 07, 2003 at 12:31:36PM +0100, harm 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 sy
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,
On Fri, Jan 03, 2003 at 08:24:17PM -0500, Brian Lindner wrote:
> harm,
>
> 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 ju
harm,
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, that should be used by the
orderby
clause. This way your
Hello,
I am trying to get a sort to use an index. The query is very simple:
select nr from mytable where col1='const' and col2='another const' and col3='YA
const' order by nr;
The explain gives me:
+-+--+--+---+-+---+--+
