There is some ASU configuration not scan the full table data?
ASU scans only the data in the result set. There is no switch available to ASU that enables it to scan the full table data. So, in order to scan full table data, you might want to execute a "SELECT *" on the table.
ASU scans only the data in the result set. There is no switch available to ASU that enables it to scan the full table data. So, in order to scan full table data, you might want to execute a "SELECT *" on the table.
I asked, because in my tests, when the updating field column width is in the Where clause, ASU scan full table, but return only data.
I use this script for verification the reading:
SELECT "_usertablestat"."_usertablestat-conn",
"_file"."_file-name",
"_usertablestat"."_usertablestat-read"
FROM <DB>."pub"."_usertablestat"
INNER JOIN <DB>."pub"."_file"
ON "_file"."_file-number" = "_usertablestat"."_usertablestat-num"
WHERE "_usertablestat"."_usertablestat-read" > 0
AND "_usertablestat"."_usertablestat-conn" =
(SELECT "_myconn-userid"
FROM <DB>."pub"."_myconnection")