I have a database in MySQL with more than 50 tables and each one has its index, views, views of the views, stored procedures.
My question is regarding the views, when creating a view with columns of a certain table and one of those columns that I add to the view has an index, does the view also take the index of the original table? , If not, I would like to know the reason and how to solve it. :)
My view code is huge, but I'll give an example of how I do them
CREATE VIEW sox AS
SELECT inicio, fin, nombre, categoria, activo FROM entrada
WHERE inicio = '2016-08-16';
The indices are in start and end.