This will cause you problems...
Originally Posted by DMurray3
Even if you are only returning a few of the rows, you have to do a full table scan in order to do it.
Add some indexes, and then pare down the amount of data that you are trying to return, (eg. Select Count(...) from table where Col3=n group by col3) even if it's a lot less than what you want to have. Build out your aggregated data, and you should have a lot more success.
This is a signature. Everyone gets it.
PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
I'm no expert.
Take my comments at your own risk.
PDI user since PDI 3.1