how to know where to do an index on mysql code example

SHOW INDEX FROM yourtable;