I’m searching about when mysql will use join buffer to accelerate a join sql. And I noticed in mysql doc, the nested-loop-joins chapter says:

MySQL join buffering has these characteristics:
…
A join buffer is never allocated for the first nonconstant table

I’m confused about this narrative.

• What is a nonconstant table?
• Why the first nonconstant table wouldn’t have a join buffer allocated for it?