First set of record are fetched quickly but its very slow to fetch all the records
Hi All,
I have a simple query based on 2 huge tables, all the where conditions are proper and the execution plan also looks good. Those 2 tables are really huge but my query fetches only around 300 thousand records.
When I run the query, first set of records will be fetched in franction of seconds but when i try to fectch all the 300 thousand records then it is taking very longtime.
My requirement is to load all those 300 thousand records into a Global Temporary table, so when i try to load those 300 thousand into the temp tables, its running long.
Statistics are gathered and the execution plan is also looking good. Please help.
I have a simple query based on 2 huge tables, all the where conditions are proper and the execution plan also looks good. Those 2 tables are really huge but my query fetches only around 300 thousand records.
When I run the query, first set of records will be fetched in franction of seconds but when i try to fectch all the 300 thousand records then it is taking very longtime.
My requirement is to load all those 300 thousand records into a Global Temporary table, so when i try to load those 300 thousand into the temp tables, its running long.
Statistics are gathered and the execution plan is also looking good. Please help.
0