Does MySQL have an equivalent of SQL Server "indexed views"?

Does MySQL have an equalavent to SQL Servers "indexed view" functionality?

Is a view faster than a simple query?

What I'm specifically looking for is a way for MySQL to create a "view" that will return result开发者_JAVA百科s faster than simply performing the underline view's query/sql.

An Indexed View is SQL Server terminology for a materialized view, which MySQL does not support.

You can either:

• re-create a temporary table, populated with the desired columns, at a given interval
• use an actual table, populated and indexed though again - there'd have to be a process to keep the data and indexes current