DOL Table: What exactly is a clustered index?

There seems to be a great deal of confusion as to what a clustered index on a Data Only Locked table (Data page locked or row level locking) actually is.

A clustered index on a DOL table is really a NONCLUSTERED INDEX.  The index key of this pseudo-clustered index is used for sorting the data when you perform a reorg rebuild.  That’s about it. 

Share Button

One Reply to “DOL Table: What exactly is a clustered index?”

  1. DOL uses OAM Page for traversing the pages (There is no Page-Linkage).

    APL uses page linkage (Bi-directional) and pages are sorted as per the clustered index. CL may be a non-unique one (Overflow pages)


Leave a Reply

Your email address will not be published. Required fields are marked *