Hi
Fellows
i have simple statment like
select lob, substring(Entrprisename 13,9), sum(offered), sum(handled)
from TableA
group by lob, substring(Entrprisename 13,9)
order by lob, substring(Entrprisename 13,9)
I know the problem is because of including substring( Entrprisename 13,9) in group by,This looks simple but when it comes to large size data, the performance is horrible
Anybody know workaround
Thanks
simon