I have added a SELECT /*+USE_CONCAT*/ at my query. I found great difference at SQL Developer (only top 200 rows) but I can't say that I found the same improvement at SSIS. Maybe that's because of the huge number of the returned records but I also have a suspicious that /*+USE_CONCAT*/ is considered as a comment. Does anyone know more about it? Thanks in advance.
As I found out, hints are totally applicable.