Hi Experts,
I need help in optimizing script to take less amount of time in loading.
I have one month is data and every day its like approx 2,50000 records.
The requirement is
Day1
ID Status
1 No
2 No
Day2
ID Status
1 No
2 No
Day3
ID Status
1 No
3 No
Now when the user wants to compare Day1 and Day3 with respect to Day1 ID's.
i.e As ID 2 is not present in Day3 I just want to assign a status of Yes by creating a record.
I did achieved it by creating composite key of ID and Date but its taking like more than an hour to load.
So Is there any better way to attain this in less amount of time?
Thanks
Syed
