how to know the sql join size taken by the query? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be rea开发者_JAVA技巧sonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

knowing the join size or combinationns taken by the query can help me to optimize the query

---

Whatever query are you using add EXPLAIN at the beginning, for example:

EXPLAIN SELECT * FROM sometable WHERE id < 1000

and look for estimated number of rows that mysql would need to check.