INTRODUCTION

Drupal custom fields do not add indexes to field values by default. This will cause a problem. When you expose this field as a search field in views, the execution will scan the entire table. The performance will be very slow.

You can use the following to test

EXPLAIN SELECT * FROM node__body WHERE body_value LIKE "hello"

You can see that the number of rows is the total number. This is because MySQL will perform a full table scan for non-indexed table searches.

HOW TO USE

• go to /admin/structure/types/manage/yourtypes/fields
• edit this field and chose Add Index
• save and run drush entity-updates(https://www.drupal.org/project/devel_entity_updates)