By slow I mean its taking more than 10 minutes which is not acceptable as this would form the query for the dataset of a ssrs report.