title: update query takes too much time
body: <p>I have dataset with 10 million data and I am looping through it and using values of dataset for updating the base table of count 25 million.</p>
  
  <p>the fields which is used in where clause is primary key.</p>
  
  <p>but still I am not getting performance only 100k records getting updated in 1 hr.</p>
  
  <p>how do I optimize and speed up time to execute query in oracle.</p>
  
  <p>I am using command object, Connection object in vb.net</p>
  
  <p>following function executed 10 million time to update query.</p>
  
  <pre class="lang-vb prettyprint-override"><code>public cmd_obj as new oledb.oledbcommand
  Strquery="update Table1 set field1='Value from dataset' where field2='value from dataset'" ' where field2 is primary key in base table
  Public Function Executenonquery(ByVal Strquery As String) As Int32
    Dim intUpdated As Int32 = 0
    Try
      If VerifyOracleLogin() = True Then ' check oracle connection
        cmd_obj.Connection = dbconn
        cmd_obj.CommandText = Strquery 'strquery has update query
        intUpdated = cmd_obj.ExecuteNonQuery()
        return intUpdated
      End If   
    Catch ex As Exception
      WriteToErrorLog("Query Execution Error : " &amp; Strquery, ex.Message)
      Return -1
    End Try
  End Function
  </code></pre>