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:



        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?