Still not helping.

We are using a filter "where comp.comp_type = 1" in the query.

If I change the filter comp.comp_type = 2 then it is taking only 15 seconds.

We have 3 comp types in table

Comp_type Count

1 1

2 341

3 21374