ASU - AUTONOMOUS SCHEMA UPDATE - Forum - OpenEdge RDBMS - Progress Community

ASU - AUTONOMOUS SCHEMA UPDATE

 Forum

ASU - AUTONOMOUS SCHEMA UPDATE

This question is answered

There is some ASU configuration not scan the full table data?

Verified Answer
  • 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.

All Replies
  • 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")