Comment 3 for bug 1671152

Revision history for this message
Rick Pizzi (pizzi) wrote :

After OPTIMIZE TABLE, cost for using index is correct and index is used:

                "table": "`BIG_STORAGE_TOKU`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "access_type": "ref",
                      "index": "HASH_ID_IX",
                      "rows": 9,
                      "cost": 10.8,
                      "chosen": true