I have a table with 80 lacs plus rows and the other table with 50 rows.
I want to join both the table fetch columns from the large table for only 50 keys in the small table.
Right now I’m using join to fetch the data but the execution time is too much around 19 hours.
Is there any way I can run the query on large table for only those 50 keys in small table.
I want to know if there is any other efficient way using SAS or Proc SQL or SQL.