- a simple folder, containing items based on columns in a single database table or view
- a custom folder, based on SQL statements
- a complex folder, containing items from one or more base folders
- When we use complex folders, the sql queries are automatically optimized by Discoverer. If we use view, we cannot get that improved performance.
- We can create complex folders without database privileges, but for view creation we require that.
Leave a Reply
Want to join the discussion?Feel free to contribute!