We have one table like:
Its columns are as below:
number [numeric(10)] name [varchar(10)] status [tinyint(1)] type [tinyint(1)] createdDate [datetime]
This table have around 250-300 million rows.
Now our requirement is that we will generate random numbers in big quantity i.e. 1 million. We want to check that this generated numbers are there in above table (with number column) or not.
How best we can do this?
-> Random numbers will be generated in application logic.
-> I want to know strategy / pseudocode how best we can design?