Assume $A$ and $B$ are commutative algebras with $1$, $B = A[z] = A[Z]/(h(Z))$, $Z$ an indeterminate. The first comment in this question says that, if $A$ is noetherian, then $pd_{B\otimes_A B}(B) \in \{0,1,\infty\}$.
Please, two questions (when $A$ is noetherian):
(1) How one proves the claim in the comment?
(2) What additional conditions one can impose in order that $pd_{B\otimes_A B}(B) \neq \infty$? For example, if we know that $B$ is separable over $A$ then, by definition, $pd_{B\otimes_A B}(B)=0$. Another (less trivial) example is: If $B$ is smooth over $A$, then by Rodicio's Corollary 2 $fd_{B\otimes_A B}(B) < \infty$. Other ideas are welcome.