[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: ASU - AUTONOMOUS SCHEMA UPDATE

  • Thread starter Thread starter maicon.putton
  • Start date Start date
Status
Not open for further replies.
M

maicon.putton

Guest
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 ."pub"."_usertablestat" INNER JOIN ."pub"."_file" ON "_file"."_file-number" = "_usertablestat"."_usertablestat-num" WHERE "_usertablestat"."_usertablestat-read" > 0 AND "_usertablestat"."_usertablestat-conn" = (SELECT "_myconn-userid" FROM ."pub"."_myconnection")

Continue reading...
 
Status
Not open for further replies.
Back
Top