1 Reply Latest reply on Oct 24, 2012 5:53 PM by Govind Nair

    Changing the Filters causes huge wait time

    Govind Nair

      Hi Guys,

       

      Currently I am hooking up a custom query for a scatter plot on tableau server. The query in itself is quite fast when I execute in (<1sec). But when I change the filters in tableau, it takes ages to update or crashes. This is the gist of the query is

       

       

      select A.stuff stuff, B.stuff, c.stuff

      from

      table A,

      table B,

      table C,

      where conditions A1, B1 ,C1

       

      union all

       

      select A.otherstuff  sutff, b.stuff, c.stuff

      from

      table A,

      table B,

      table C,

      where conditions A1, B1 ,C1

       

      I have attached the query itself, incase that helps.

       

      any ideas what I should do?

       

      Govind