1 Reply Latest reply: Oct 31, 2014 11:52 AM by André Gomes RSS

    Direct Query slow loading

      I am attempting to use Direct Discovery for the first time.

       

      I have a table holding 70 million rows of textual description data, which I only ever want to load into memory once I drill down to a specific record.

       

      However, I must be doing something wrong.  I have this:

       

      DIRECT QUERY

        dimension KEY_FIELD

        detail DESCRIPTION

      from SA.TABLE;

       

      But whenever I refresh the report, it seems to want to load 70 million rows into memory.  This seems to defeat the point, as it would take half an hour to run - how do I get this to work without it having to load all of the KEY_FIELDS into memory?

       

      Thanks!