Isn't the "physical plan" the part that gets the "set of tuples", not the "logical plan"? And isn't that matter of how that gets done more a concern of which p

Isn't the "physical plan" the part that gets the "set of tuples", not the "logical plan"? And isn't that matter of how that gets done more a concern of which physical plan the query optimizer picks, and as a result the query engine that powers that particular data-layer?