Hi
I have this situation: I am running a query in data warehouse, fact table joined with dimensions. It comes up in about 30 sec in toad and displays the results in grid. The same query when executed on reporting layer (reporting layer fetches all the data before displaying a report), it takes 2 mins to show the data. This reporting tool fetches all the data before displaying the results. I think, fetching whole data set is taking about 2 mins vs in toad, I think it is displaying first few fetched rows. For me it seems like query is performing fine, but bottleneck is with getting complete data set.
1. Is there any scope to improve fetch performance for fetching whole data?
2. how do I test this scenario in TOAD and check how much time is it taking to fetch complete result set?
please advice.
thanks
kum