Finding the number of hashed columns and subtrees in a forest of trees index

You can look up the number of hashed columns and subtrees in a forest of trees index by viewing information in the sysindices table for the database containing tables that have forest of trees indexes.

To view information about a forest of trees index:

  1. Query the sysindices table for the index.
  2. Go to the row containing the forest of trees index and view information in the nhashcols and nbuckets columns.

Copyright© 2019 HCL Technologies Limited