Is it possible to have an indexed view in MySQL?

by

I don’t think MySQL supports materialized views which is what you would need, but it wouldn’t help you in this situation anyway. Whether the index is on the view or on the underlying table, it would need to be written and updated at some point during an update of the underlying table, so it would still cause the write speed issues.

Your best bet would probably be to create summary tables that get updated periodically.

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL dump by query
  8. MySQL’s now() +1 day
  9. Delete sql rows where IDs do not have a match from another table
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Can you access the auto increment value in MySQL within one statement?
  13. Which SQL query is better, MATCH AGAINST or LIKE?
  14. What does DELIMITER // do in a Trigger?
  15. MySQL, Get users rank
  16. Mysql: how to select groups having certain values?
  17. How to fill date gaps in MySQL?
  18. Adding a new SQL column with a default value
  19. Boolean vs tinyint(1) for boolean values in MySQL
  20. MySQL full text search for words with three or less letters
  21. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  22. Function for week of the month in mysql
  23. MySQL’s alternative to T-SQL’s WITH TIES
  24. Find rows that have the same value on a column in MySQL
  25. what is the difference between GROUP BY and ORDER BY in sql
  26. How important are lookup tables?
  27. How to find all IDs of children recursively?
  28. how to use LIKE with column name
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment