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
After OPTIMIZE TABLE, cost for using index is correct and index is used: