title: Update join vs Update with sub query
body: <p>I have 2 tables :</p>
  
  <pre><code>Table A 
  
  ID int,
  Name varchar,
  Address varchar
  
  
  Table B 
  
  ID int,
  Name varchar,
  Address varchar,
  Col1...
  ...
  Col100
  </code></pre>
  
  <p>I want to update A.Name with B.Name based on both table's ID.</p>
  
  <pre><code>UPDATE A 
      SET A.NAME = B.NAME 
      FROM A JOIN (SELECT ID, Name　from B) AS B ON A.ID = B.ID 
  
  UPDATE A 
      SET A.NAME = B.NAME 
      FROM A JOIN B AS B ON A.ID = B.ID 
  </code></pre>
  
  <p>Because I don't have the permission to set the option for viewing execution plan, I ran 2 queries above many times and see the processed time to guess which one has better performance. </p>
  
  <p>With about 700k records, both queries's result slightly differ. </p>
  
  <p>So my question is, if executed, will both queries have the same execution plan? (I mean will the database engine process them by the same way? )</p>
  
  <p>P/S : I'm using SybaseIQ 16.0.0.429</p>
  
  <p>Update : I'm getting the permission for viewing the execution plan. In case both plan are identical, does is mean both queries will be processed the same (100% sure) ?</p>