Dynamic View is similar to SQL View but we can not build 
the dynamic view. When we dont want store the data base 
then us dynamic view.

Dynamic view that can be used like a view in pages and 
PeopleCode, but is not actually stored as a SQL view in the 
database. Instead, the system uses the view text as a base 
for the SQL Select that is performed at runtime. Dynamic 
views can provide superior performance in some situations, 
such as search records and in PeopleCode Selects, because 
they are optimized more efficiently than normal SQL views.