How to use cardinality in SQL?

Could you please elaborate on how cardinality can be effectively utilized in SQL queries? Specifically, how does it impact query performance and what are some best practices for leveraging it to optimize database operations? Additionally, are there any common pitfalls to avoid when incorporating cardinality into SQL strategies?