They can materialize (persist) the the results of view in a table-like form

 They can help to simplify complex queries and join data from multiple tables 

They can combine data from one or more base tables (or views) into a new virtual table

They can join horizontally partitioned data from one or more base tables across one or more servers