Indexing views in MySQL

You can not do anything specific like that. If the view is not meeting the performance requirements it has three outputs:

• Do not use view , access the data directly from the tables, you may find that the problem was not even in view and you have to fix the problem that was below.
• Create indexes that help your searches to be efficient on the physical table, after all that is what matters in fact, indexes are optimizations to access the actual data, not logical data that is the view function. view will benefit if the physical table benefits.
• Create an auxiliary table with the data you would get from the view (its existence even facilitates this, it is a simple insert/select ) and index it. I know this is not ideal, but it is still an alternative.

To use Indexes in View simply update MySQL to version greater than or equal to 5.6.3, from this version MySQL uses the index derived from the physical table.