Joining or keeping two different table with same numbers of rows
Dear Experts,
I am facing a situation to handle huge data set with example given below:
"Main_Table" consists of 200+ fields and about 3 million rows and on the other hand our values table "Matrics_table" having 10 fields but same number of rows as in "Main_Table", now my question here is, what is the best practice to merge these all fields into one table because when I tried using "join" it takes too much time and in other words looks not practical to handle through join. Seeking your help with smart solution plssss.