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 syntax
for
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 columns as
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
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 syntax
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 just the
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, that
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 columns as
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