What is a clustered index?

devquora
devquora

Posted On: Feb 22, 2018

 

The clustered index is a unique type of index. This rearranges the order or manner in which the data or information of the table are stored. Also, the rows due to this type of index are stored on the disk, physically as per the index. Hence, there exists one single type of clustered index for one table. And the data pages are stored in the leaf nodes of this clustered index.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mainframe Interview Questions

    What is the difference between LINK and XCTL?

    Link is used to go from one module to another and then return to the first module such that the link to a module is used to provide the first some data. Whereas XCTL is used to go from one module with...

    Mainframe Interview Questions

    What is the difference between the MRO & ISC?

    MRO or Multiregion operation is influenced by the intercommunication facilities that you use with the connection and by your management of the connection. Whereas ISC or intersystem communication s sh...

    Mainframe Interview Questions

    What happens when a CICS command contains the NOHANDLE option?

    In CICS the NOHANDLE option is used to suspends the error handling that was specified in previous EXEC CICS HANDLE CONDITION commands but only for the command on which you put the NOHANDLE....