SQL query takes 6 hours to execute

[hrishy]

Hi

Whats the output of

select ATTRIBUTE_XID,count(*)
from MAM_ATTR_STRING_VALUES
group by ATTRIBUTE_XID

select count(*)
from MAM_ATTR_STRING_VALUES