parhamr · December 25, 2015 17:18 · Oct 17, 2013 · Oct 16, 2013 · Oct 16, 2013 · Oct 16, 2013
diff --git a/SQLexample.md → Magento1.12-SQL_type_example.md b/SQLexample.md → Magento1.12-SQL_type_example.md
@@ -14,7 +14,11 @@ possible_keys: NULL
          rows: 773625
         Extra: Using where
 1 row in set (0.00 sec)
+```
+
+This query is much faster:
 
+```sql
 mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN(433284, 433283)\G;
 *************************** 1. row ***************************
            id: 1
@@ -30,3 +34,20 @@ possible_keys: PRIMARY,IDX_CATALOGPRODUCTINDEXPRICE_ENTITYID
 1 row in set (0.00 sec)
 ```
 
+Incorrectly quoting both INT values produces the same result:
+
+```sql
+mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', '433283')\G;
+*************************** 1. row ***************************
+           id: 1
+  select_type: SIMPLE
+        table: catalog_product_index_price
+         type: range
+possible_keys: PRIMARY,IDX_CATALOGPRODUCTINDEXPRICE_ENTITYID
+          key: PRIMARY
+      key_len: 4
+          ref: NULL
+         rows: 19
+        Extra: Using where
+1 row in set (0.00 sec)
+```
diff --git a/SQLexample.md b/SQLexample.md
@@ -1,4 +1,4 @@
-Removing quotes from an INT column allows MySQL to use the index and this can reduce rows scanned by __99.997 percent__. Example from Magento 1.12 on a production database:
+Removing quotes from an INT column allows MySQL to use the index and this can reduce rows scanned by __99.997 percent__. Example from Magento 1.12 on a production database; the query takes nearly a second to execute:
 
 ```sql
 mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', 433283)\G;

diff --git a/SQLexample.md b/SQLexample.md
@@ -1,4 +1,4 @@
-Removing quotes from an INT column allows MySQL to use the index and this can reduce rows scanned by __99.997 percent__. Example from Magento 1.12:
+Removing quotes from an INT column allows MySQL to use the index and this can reduce rows scanned by __99.997 percent__. Example from Magento 1.12 on a production database:
 
 ```sql
 mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', 433283)\G;

diff --git a/SQLexample.md b/SQLexample.md
@@ -1,4 +1,4 @@
-Removing the quotes from the INT column allows MySQL to use the index and this reduces the rows scanned by __99.997 percent__. Example from Magento 1.12:
+Removing quotes from an INT column allows MySQL to use the index and this can reduce rows scanned by __99.997 percent__. Example from Magento 1.12:
 
 ```sql
 mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', 433283)\G;

diff --git a/SQLexample.md b/SQLexample.md
@@ -1,3 +1,5 @@
+Removing the quotes from the INT column allows MySQL to use the index and this reduces the rows scanned by __99.997 percent__. Example from Magento 1.12:
+
 ```sql
 mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', 433283)\G;
 *************************** 1. row ***************************
@@ -28,4 +30,3 @@ possible_keys: PRIMARY,IDX_CATALOGPRODUCTINDEXPRICE_ENTITYID
 1 row in set (0.00 sec)
 ```
 
-Removing the quotes from the INT column allows MySQL to use the index and this reduces the rows scanned by 99.997 percent.
diff --git a/SQLexample.md b/SQLexample.md
@@ -0,0 +1,31 @@
+```sql
+mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN('433284', 433283)\G;
+*************************** 1. row ***************************
+           id: 1
+  select_type: SIMPLE
+        table: catalog_product_index_price
+         type: ALL
+possible_keys: NULL
+          key: NULL
+      key_len: NULL
+          ref: NULL
+         rows: 773625
+        Extra: Using where
+1 row in set (0.00 sec)
+
+mysql> explain DELETE FROM `catalog_product_index_price` WHERE entity_id IN(433284, 433283)\G;
+*************************** 1. row ***************************
+           id: 1
+  select_type: SIMPLE
+        table: catalog_product_index_price
+         type: range
+possible_keys: PRIMARY,IDX_CATALOGPRODUCTINDEXPRICE_ENTITYID
+          key: PRIMARY
+      key_len: 4
+          ref: NULL
+         rows: 19
+        Extra: Using where
+1 row in set (0.00 sec)
+```
+
+Removing the quotes from the INT column allows MySQL to use the index and this reduces the rows scanned by 99.997 percent.