Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Main_Table:
Key,field1,field2....field200
-----------------------
Matrics_table:
Key,fee1,fee2...fee10