Is derived table different from view? If yes, then how? Which one is preferable?

devquora
devquora

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Business

    What do you mean by Business Object?

    Business Objects are designed for the business professionals to help them for retrieving the data..

    Business

    What are the characteristics of Business Objects?

    It has some characteristics which are described below:..

    Business

    List some advantages of using Business Object?

    Business Objects have many pros which are shown below:..