13 Replies Latest reply: Apr 15, 2015 5:44 AM by Hartley Julian RSS

    Fast retrieve of distinct values

    Hartley Julian

      hi All,

       

      I'm throwing this one out there for discussion. I have a feeling that I've seen it discussed before, but can't find the thread!

       

      Regularly I will have a large table that I will then need to retrieve distinct values of dimensional fields from in order to display in selection boxes etc. This obviously impacts the load significantly as it has to load the full table each time.

       

      Any ideas on ways to improve this process? (Flags, group by's etc.)

       

      Thanks!

       

      ps. As pointed out below - the reason for doing this is that I need a separate table that is not linked to the main table