This discussion is archived
1 Reply Latest reply: Jul 3, 2013 6:46 AM by ChrisJenkins RSS

TblLkTtreeScan and RowLkTtreeScan - Difference.

sgracelin Newbie
Currently Being Moderated

In query plan, both  TblLkTtreeScan and RowLkTtreeScan operation its mentioned as range scan. What is the actual difference between those?? When will we see TblLkTtreeScan/RowLkTtreeScan in Query plan and which is recommended among them?

  • 1. Re: TblLkTtreeScan and RowLkTtreeScan - Difference.
    ChrisJenkins Guru
    Currently Being Moderated

    Both mean that the table is being accessed via a Ttree (range) index. TblLk means the access will use table level locking while RowLk means it will use row level locking. In most cases indexed access is  better than a serial scan. For maximum concurrency row level locking is best (typically for OLTP workloads). For complex query workloads (e.g. analytics) with no concurrent updates table level locking often gives better performance.

     

    Chris