I was running a query in production region. It involved 4 tables and it gave the desired results in 12 sec. The same query when I ran in test region it produced the result in 14 sec. The query used 4 tables and I rebuild the indexes and analyzed the table statistics. I put the query in report builder and ran the report through front end. It was taking nearly 2.5 hrs. What might be the issue in this?
Note: Report server is up and I used parallel hint in the query. Out of 4 tables in 2 tables (a and b) volume is high so I used the hintparallel(a) parallel(b)