HANDLER statements gives you direct access to reading rows from the storage engine. This is much faster than normal access through
SELECT as there is less parsing involved and no optimizer involved.
HANDLER CommandsDirect access to table storage engine interfaces for key lookups and key or table scans
HANDLER for MEMORY TablesUsing HANDLER commands efficiently with MEMORY/HEAP tables