We have a check on many queries in our application that joins 3 tables together. I want to create a view or MV so as to improve performance.

After reading up on MVs and Views I am a little confused what would be best.

The end result does not do aggregates and only checks against 3 or 4 fields that lie in the 3 tables of the join.
The data does not change or update very often in any of the 3 tables.
Also, the 3 tables do not hold a large amount of data.

Are MVs MAINLY for aggregates or very large tables? Or are they more efficient than views in general?

The only requirement would be that when new rows periodically get inserted into the 3 tables (they are dependant upon each other) that the view or MV reflect the new rows.

Thanks for your advice.