0 Replies Latest reply: Dec 17, 2012 10:54 AM by user515913 RSS

    query execution taking longer time

    user515913
      Hi,
      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)

      Suggestions welcome.

      thanks,
      Selva