I see this definition of a clustered view:
Designing Indexed Views. ... If such views are frequently referenced in queries, you can improve performance by creating a unique clustered index on the view. When a unique clustered index is created on a view, the result set is stored in the database just like a table with a clustered index is stored.
Is it possible to create such a view in DB2 for i? The view will join multiple tables.
I have an SQL statement that joins multiple tables and sometimes it takes more than 3 minutes to get the result set.
What are the pros and cons?
Will performance improve? Can we make more than 1 unique clustered index on the view? Is there a concern on the amount of memory it will use up?