Hi all,

can anybody help me with index to create for following query:

SELECT DISTINCT AREA_ID
FROM TMP_CKRAJ
WHERE
(ID_CCOUNTRY = 'CZE') AND
(NAME_TYPE = 'B')
GROUP BY AREA_ID
HAVING
(COUNT(AREA_ID) > 1)

It's easy to make an index for ID_CCOUNTRY and NAME_TYPE, but is there
any chance to help engine with index that can be used for DISTINCT/GROUP
BY/HAVING COUNT ?

Thanks

Milan Tomes