I've a table like that
Table name : table1
And I use indexes in (a_name,a_id (Primary key), a_code,a_number)
Now I want to make select * from table1 to get all of the data
However no indexes are use in explain query, How I can tell the query to use index without using the where clause for sure as I don't want to specific the values.
Also I tried use index and force index and nothing changed