Re: distinct clause issue for 600000 records
Posted by:
Ra Nala
Date: November 12, 2015 07:18AM
yes you are correct indexes on id columns, performance should not be an issue.
and i can write sub select Sir, but here i given my sample query as small one but actually query having lot of LEFT joins.
In this case i should not go for "sub select" why because i need to retrieve millions of records may be nearly 600000 to 5000000 records.
I am using ETL tool as Pentaho data integration that is not able to load 5000000 records at the same time. unable to process in temp table due to this reason i missing records.
Subject
Views
Written By
Posted
2048
November 10, 2015 08:57AM
1151
November 11, 2015 12:33PM
1032
November 12, 2015 12:49AM
1146
November 12, 2015 03:20AM
1048
November 12, 2015 07:24PM
1263
November 12, 2015 07:08AM
Re: distinct clause issue for 600000 records
1253
November 12, 2015 07:18AM
1301
November 12, 2015 07:43AM
1170
November 13, 2015 12:37AM
1290
November 13, 2015 12:45AM
1323
November 13, 2015 02:42AM
1324
November 13, 2015 05:56AM
1126
November 13, 2015 06:38AM
1221
November 13, 2015 07:15AM
1184
November 13, 2015 08:11AM
1139
November 13, 2015 11:35AM
1213
November 16, 2015 03:04AM
1137
November 16, 2015 04:12AM
1078
November 16, 2015 05:54AM
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.