Re: how to optimise query for 10+ millions records
Posted by:
Azhar Rahi
Date: February 09, 2012 05:38AM
Thats not exactly what you have understood. In fact the query return the records by sum up some fields using with group by clause. In fact the query returns the records group by destination. However still it need to manipulates the thousands of records to retrieve the desired result.
Subject
Views
Written By
Posted
2852
February 09, 2012 03:30AM
1694
February 09, 2012 05:31AM
Re: how to optimise query for 10+ millions records
1357
February 09, 2012 05:38AM
1258
February 09, 2012 05:58PM
1244
February 11, 2012 11:26PM
1493
February 12, 2012 10:12PM
1348
February 13, 2012 02:18PM
1557
February 14, 2012 02:33AM
1340
February 14, 2012 07:24AM
1366
February 15, 2012 07:30AM
1821
February 16, 2012 03:54AM
1259
February 17, 2012 01:20AM
1218
February 17, 2012 03:57PM
1500
February 17, 2012 05:12PM
1301
February 18, 2012 07:18AM
1366
February 21, 2012 03:25AM
1356
February 24, 2012 10:45AM
1297
February 20, 2012 02:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.