Hi everyone,
More time to be taken when i execute query using (group by +
order by) or (group by + cast + order by) in same query. Kindly refer the
following query
Could you please provide any solution regarding thisd performance issue?
SELECT If(ISNOTNULL(SUM(CAST(adventurepersoncontacts.contactid AS
decimal(38,6)))),SUM(CAST(adventurepersoncontacts.contactid AS
decimal(38,6))),0) AS adventurepersoncontacts_contactid,
adventurepersoncontacts.fullname as adventurepersoncontacts_fullname FROM
default.adventurepersoncontacts AS adventurepersoncontacts order by
adventurepersoncontacts.fullname asc
Regards,
Ravisankar M R
