what is dynamic view?

Answer Posted / kiran

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.

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between key and alternate search key?

686


What are the built-functions used to control translate values dynamically?

665


Explain the field values for tools tables?

721


What is auto update?

694


Tell me the use of set control field in record field properties?

668


Explain what is peoplecode meta data?

698


What are the different ways we can set up the portal security to access component in portal?

688


What is difference between field default and row init?

924


How to bring advanced search page before normal search page?

660


What is the use of temporary records and state record in application engine?

664


Explain mandatory property of app.engine?

631


What is page meta data?

630


What conditions are required to establish parent child relationship between two records?

865


Can you please explain the difference between temporary table and sql view in peoplesoft?

714


What is maximum dimension of an array?

687