When I run describe extended on the table it shows Statistics as 308105571 bytes, 144413 rows which is the real reason why this query is so slow. Even though count(*) returns 1 on this table the query is scanning almost 0.3GB of data as it a delta share. Can you share how often VACUUM is run on these tables?