3 Replies Latest reply on Nov 7, 2016 3:59 PM by Marc MOUSSA

    What's faster--one long custom SQL query, or multiple shorter ones?

    Sarah McGraw

      Just what the title says.

       

      I am pulling in data with a long(but simple) query--- a ton of unions, plus a handful of extra joins.

       

      Is it faster to:

      * do all  this as one big long custom SQL?

      * to do the unions in one query and the joins in another?

      *  or even to do each part of the union as its own query and join them in Tableau?

       

      Are there considerations besides speed/ performance that I should be taking into account?

       

      Thank you!