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.