In order to improve performance, I am trying to update statistics on a volatile table that I created and inserted data into. This is the statement:
update statistics for table VT_HIER_WITH_REVENUE_FLASH_BUDGET on every column, (FISC_YR_QTR_DSPLY_CD, PRFT_CTR_GRP_DN, PRFT_CTR_LVL_0_DN, PRFT_CTR_LVL_1_DN, PRFT_CTR_LVL_2_DN) sample;
Without the SQL, the command fails with syntax error, so I am using this to indicate this is a SQL command. With the SQL in there, the script run stops and fails. Has anyone successfully updated stats on a volatile table in Qlikview?