Attached is the execution plan AND object definition....

I edited query..even below query not returning count after more than 1 hour...not able to count total rows as well on below table..but seems it's millions of rows.

SELECT

...

yes, thats why i am looking for another options available ..like index view..let me know if you have any suggestions

Hey Lokesh..I can't ignore these condition 🙁

(a.Valuekey LIKE '%Description%' OR

a.ValueKey LIKE '%Box Number%' OR

(a.valuekey IS NULL AND

a.value1 IS NOT NULL)

Hi Gail.. Please let me know if you have any suggestions... Actually, i created materialized views in oracle at this situation. So that's why i may want to choose this....

Thanks for responding..Any suggestions how to create index view on below query.

SELECT

CASE

WHEN a.ValueKey LIKE '%Description%' THEN 'Additional Description Changed'

WHEN a.ValueKey LIKE '%Box Number%' THEN 'Box...