The Entry Point table represents the indexes defined using the DSD.
It records the index name (Name), whether it is clustered or not (Clustered), whether it is partitioned or not (Partitioned), the indexspace (Data_Str_Ndx_ID) that contains the index, the identifier (Identifier_ID) implemented by the index, if any, and the relationship or partitioning implementation (Rel_Impl_ID) that uses the index, if any.
The Entry Point table is maintained by the DSD Detail Entry Point Name and Properties option.
A record entry point may be created as a result of implementing an identifier, relationship, or partitioning, or it may be added for performance reasons. If the entry point is added for performance reasons, both the identifier (Identifier_ID) and relationship or partitioning implemented (Rel_Impl_ID) columns are zero.
If the entry point represents an identifier, the Identifier_ID is present. If the entry point is used in the implementation of a relationship or partitioning, the Rel_Impl_ID is present.
|
Copyright © 2013 CA.
All rights reserved.
|
|