indexed-view – Tarik Billa

Is it possible to have an indexed view in MySQL?

December 27, 2023 by Tarik

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 … Read more

How to create materialized views in SQL Server?

December 17, 2022 by Tarik

They’re called indexed views in SQL Server – read these white papers for more background: Creating an Indexed View Improving Performance with SQL Server 2008 Indexed Views Basically, all you need to do is: create a regular view create a clustered index on that view and you’re done! The tricky part is: the view has … Read more