ASU - AUTONOMOUS SCHEMA UPDATE

Posted by maicon.putton on 04-Dec-2017 10:47

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

Posted by Dileep Dasa on 04-Dec-2017 21:18

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

Posted by Dileep Dasa on 04-Dec-2017 21:18

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.

Posted by maicon.putton on 05-Dec-2017 04:08

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")

This thread is closed