- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber '2118806';
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber,
Il 24/07/14 11:57, Chris Knipe ha scritto:
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
Try this
SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
WHERE ArtNumber2118806)
+---+---+
| ArtNumber | MessageID
|
Hi Chris,
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Thursday, 24 July 2014 19:18
To: mysql@lists.mysql.com
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber