Posted On: Feb 22, 2018
Yes, a derived table is different from view. A derived table is created in-universe while a view is created in a database level.
Generally, the view is preferred over a derived table in cases when the onus of calculation remains in a database and it does not load the BO server. But where the developers have not right to access the database, then a derived table is the only solution there.
Never Miss an Articles from us.