How can you force MySQL to full scan a table (meaning force MySQL to ignore all indexes and choose to full scan the table in order to execute the given query)?
FORCE INDEX () with empty parenthesis | |
IGNORE INDEX () with empty parenthesis | |
FORCE ALL | |
IGNORE ALL |