Oracle SQL Performance Tuning Tips -Using ROWID When Possible a to z help

Using ROWID When Possible

•Each record added to the database has a unique ROWID and will never change until the delete statement issued on that record.

 

•If the record block or location was changed for any reason, the original ROWID points to the new location or the new ROWID and so on.

 

•Use ROWID whenever possible to get the best performance out of your retrievals

cursor accounts_cur is

  select acct_no,

         currency,

         branch

         Rowid acct_rowid,

         …

         …

  From account 

  where . . . .

  …

  for acct_rec in accounts_cur loop

    …

    update account set …

    …

    where rowid = acct_rec.acct_rowid;

    …

    …

  end loop;

Note : Provide your comments by clicking below options! Thanks ! :)

Tweet