Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

dam_describeIndex

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

This method is used to retrieve the description of the optimal index returned by the dam_getOptimalIndexAndConditions method. The information for the index is retrieved from the OA_STATISTICS table. Pass in NULL for any descriptor in which you have no interest. The output parameters to this method are objects that must be created before this method is called.

int dam_describeIndex(
int64 hIndex,
StringBuilder pszIndexQualifier,
StringBuilder pszIndexName
out int piType,
out int piNonUnique,
out int piIndexLen)

Parameters for dam_describeIndex

Parameter Type Description
IN    
hIndex int64 Index handle
OUT    
pszIndexQualifier StringBuilder Qualifier of the index. Must create an object of type StringBuilder of size DAMOBJ_MAX_ID_LEN.
pszIndexName StringBuilder Name of the index. Must create an object of type StringBuilder of size DAMOBJ_MAX_ID_LEN.
ptType int Type of information being returned.
SQL_TABLE_STAT (0) - indicates a statistic for the table
SQL_INDEX_CLUSTERED(1) - indicates a clustered
SQL_INDEX_HASHED(2) - indicates a hashed index
SQL_INDEX_OTHER(3) - indicates another type of index
piNonUnique int Indicates whether the index prohibits duplicate values
TRUE (1) if the index values can be non-unique.
FALSE (0) if the index values must be unique.
piIndexLen int The number of columns in this index. This number is as indicated in the OA_STATISTICS and does not reflect how many of the columns belonging to the index are part of the query.
RETURN    
  int DAM_SUCCESS - valid information returned
DAM_FAILURE - failure

See also

TitleResults for “How to create a CRG?”Also Available inAlert