1)We have extracted the query from stored procedure and executed on SQL server where it is getting hanged after fetching 11K records (Out of 26 K records).

2)The same query when...