We have a performance issue with a couple SharePoint farms I support, it was identified to be caused by an index created on the Content Type column. Delete the index problem solved for now. However, once a week the index reappears and slows the whole site down again.

This is a large repository with over a 100,000 documents. A slightly customized Content Query Web Part is used throughout the site to display documents based on Enterprise Keywords and I suspect this is somehow the cause.... but for the life of me I can't find what. It must be a timer job, but there are no custom timer jobs and I can't find an OOTB timer job that would do this. The content type column was originally used as a refiner in the metadata navigation (not sure why because everything has the same content type), it was removed from this area though.

The issue is repeatable within the prod environments but when I've replicated the solution in a dev environment (minus 100,000 documents) I can't replicated the issue.

Hi,

How did you remove the index for Content Type column? Did you delete the crawled property for the Content Type column?

Per my knowledge, the Content Type column is a system column in SharePoint and the crawled property for the column is ows_ContentType.

If the Search Host Controller services have been restarted, the crawled property will be re-created.

Please refer to the link below for more details:

http://blogs.technet.com/b/sharepointdevelopersupport/archive/2013/06/04/crawled-properties-won-t-re-appear-after-deletion-for-a-custom-xml-indexing-connector-in-sharepoint-2013.aspx

Thanks,

Victoria

This is not related to search.

This is an indexed column on a list or library used for filtered views generally.

• Edited by monkeymaj1k 2 hours 1 minutes ago

This is not related to search.

This is an indexed column on a list or library used for filtered views generally.

• Edited by monkeymaj1k Thursday, July 09, 2015 5:37 AM

This is not related to search.

This is an indexed column on a list or library used for filtered views generally.

• Edited by monkeymaj1k Thursday, July 09, 2015 5:37 AM

This is not related to search.

This is an indexed column on a list or library used for filtered views generally.

• Edited by monkeymaj1k Thursday, July 09, 2015 5:37 AM

Hi,

Did you remove all the associations where the indexed column was used?

I recommend you to make sure that the indexed column has been removed from the places where it was used and then check if the issue still occurs.

Thanks,

Victoria

This is the "Content Type" column getting indexed. It's not a column you can remove.

This is a content type published from a Content Type Hub and I've found the same happening on other sites where this content type is used.