Post #1
1 votes
Omar
Reputation155
Posts: 12
Joined: 01/07/2025, 10:05 AM
Posted: 07/25/2026, 11:07 AM
Predicate is on the leading column of a unique index. RUNSTATS were this week. EXPLAIN still wants a tablespace scan on a 20M row table.
Host variable is typed differently than the column (CHAR vs VARCHAR). Could that alone kill matching?