9 Replies Latest reply on Jan 21, 2017 8:42 AM by Yingying Zeng

    Advantage and disadvantage of Joining Two data extracts on the view

    Yingying Zeng

      I have two big tables from the database .When I drag the two tables and join in the view, It already took more than two hours to load the data.  Will it  be better to extract these two tables separately, then join two extracts on the view?

      The late option dramatically reduce the data loading time while I am wondering whether it is the best practice or any disadvantage of join the two extracts rather than two tables directly in the view?

       

      Please kindly help! Thanks a lot