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

Explain what is portal (structure and content)?

703


What are the rules used by the system to determine whether a user is authorized to update an object?

543


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

557


What is process scheduler information?

560


What is mandatory property of app.engine?

615






Differentiate field edit and save edit?

574


Why do peoplesoft often use views as search records?

547


Explain how to taken care performance management in people tools?

522


Does peopletools 8.4 support web server load balancing?

500


What is differed processing and its advantages?

580


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

508


How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?

2729


In which events error & warning are used most extensively?

588


What is getlevel0()? What is the use of %subrec and %selectall functions?

687


Tell me how many sub pages, secondary pages can be created in one level?

520