Hi, Jaap: The dataset are all small, about 50 MB in size. But somehow the the SQL is trying to do Cartesian product. For example, the my identifiers are numeric like below: number 1077857536 1074971904 1264943360 3236621056 1658826240 2927696128 2927735552 645046016 The numbers are large, apparently. I hope to know whether these numbers are between. Because there are millions of entry in my data, it takes about 12 days to complete the computation. Do you think there is some method to specify format so that the program will be more efficient? The only thing I care is whether the number fall between the number_start and number_end. Thanks - number_start, number_end, 16843264,16844799, 16850944,16859135, 16859136,16875519, 16875520,16908287, 16909056,16909311, 16909312,16909567, 16912384,16941055, 16941056,16973823,
... View more