mysql> alter table tbl_rf add index (macadd);
Query OK, 1691759 rows affected (1 min 42.98 sec)
Records: 1691759  Duplicates: 0  Warnings: 0

mysql>