mysql - how to know the sql join size taken by the query? -

knowing join size or combinationns taken query can me optimize query

whatever query using add explain @ beginning, example:

explain select * sometable id < 1000 

and estimated number of rows mysql need check.