What in the hsi.keytypetable indicates that the Allow Drop - Down Lists Option is selected?

[Sheryl_Lambeth]

We have encountered out of memory issues and high CPU spikes on our web servers and it has been determined that it was related to a keyword having the Allow Drop - Down Lists turned on.  I would like to query the hsi.keytypetable and quickly identify other keywords that have this option selected.  There is a column of dropdownset, however all of the keywords contain a value of 0, so I do not believe that to be the correct indicator.  

Thank you in Advance.

Sheryl

[Nick_McElheny · Accepted solution]

Hi Sheryl,

This setting is stored as a bitwise value in the keytypeflags column.  For SQL Server, the query below should return the keyword names that have the allow drop down lists checkbox enabled:  

SELECT keytype AS 'Keyword'
FROM hsi.keytypetable with (nolock)
WHERE keytypeflags & 67108864 = 67108864
ORDER BY 1

Thanks,

Nick

[Sheryl_Lambeth]

Thank you so very much.

[Kevin_Teynor]

This is not entirely true, because the keyword could ALSO have "Use Keyword Data Set" selected at the same time, which overrides "Allow Drop - Down List"