Performance of Query 7 on TPC-H Benchmark

**Describe the problem**

For query 7 in TPC-H benchmark:

```sql
select
supp_nation,
cust_nation,
l_year,
sum(volume) as revenue
from
(
select
n1.n_name as supp_nation,
n2.n_name as cust_nation,
extract(
year
from
l_shipdate
) as l_year,
l_extendedprice * (1 - l_discount) as volume
from
SUPPLIER,
LINEITEM,
ORDERS,
CUSTOMER,
NATION n1,
NATION n2
where
s_suppkey = l_suppkey
and o_orderkey = l_orderkey
and c_custkey = o_custkey
and s_nationkey = n1.n_nationkey
and c_nationkey = n2.n_nationkey
and (
(
n1.n_name = 'JAPAN'
and n2.n_name = 'INDIA'
)
or (
n1.n_name = 'INDIA'
and n2.n_name = 'JAPAN'
)
)
and l_shipdate between date '1995-01-01'
and date '1996-12-31'
) as shipping
group by
supp_nation,
cust_nation,
l_year
order by
supp_nation,
cust_nation,
l_year;
```

Its execution time is 15.7s, as shown in its query plan
[original.txt](https://github.com/user-attachments/files/17721622/original.txt)

I found that negatingthe following IF code block brings a significant performance improvement:
```patch
diff --git a/pkg/sql/opt/memo/statistics_builder.go b/pkg/sql/opt/memo/statistics_builder.go
index 5e3bd1d1a5e..bf9edfab2b2 100644
--- a/pkg/sql/opt/memo/statistics_builder.go
+++ b/pkg/sql/opt/memo/statistics_builder.go
@@ -1404,7 +1404,7 @@ func (sb *statisticsBuilder) buildJoin(

default:
s.RowCount = leftStats.RowCount * rightStats.RowCount
- if h.rightProps.FuncDeps.ColsAreStrictKey(h.selfJoinCols) {
+ if !h.rightProps.FuncDeps.ColsAreStrictKey(h.selfJoinCols) {
// This is like an index join, so apply a selectivity that will result
// in leftStats.RowCount rows.
if rightStats.RowCount != 0 {
```

Its execution time is reduced to 5.4s, as shown in the new query plan
[derived.txt](https://github.com/user-attachments/files/17721633/derived.txt)

I am not proposing a fixing patch. Instead, I believe this case shows that the optimizer produces a more efficient query plan based on the current implementation. I wonder whether we can optimize the code anywhere to enable the second query plan.

**To Reproduce**

```sql
cockroach start-single-node --insecure --store=/app/data --listen-addr=0.0.0.0:36257 --sql-addr=0.0.0.0:26257
cockroach workload init tpch
```
Then execute the above query.

**Environment:**
- CockroachDB version [dcb0d27]
- Server OS: [Ubuntu]
- Client app [`psql "postgresql://root@127.0.0.1:26257/tpch"`]

Jira issue: CRDB-44256

Jira issue: CRDB-44329