Home » Databases » Sybase » ASE » DOL Table: What exactly is a clustered index?

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

Comments

  1. KRV says:

    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)

    Thanks
    KRV

Leave a Reply

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

*
*

Facebook login by WP-FB-AutoConnect