Tag Info

New answers tagged


OBSERVATION #1 The MySQL Documentation gives you the Restrictions on Views It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used ...

Top 50 recent answers are included