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 getlevel0()? What is the use of %subrec and %selectall functions?

660


Explain what is process scheduler information?

458


What is html & image meta data?

507


What is page meta data?

479


What is the use of %subrec and %selectall functions?

685






You want to create a prompt table dynamically for a specified field. How would you do that?

497


Explain what is sql definitions?

582


How to authorize the user to run a process or report?

529


What are the options for using sql in people code?

440


Situation: you want to connect report through process scheduler. How would you do that?

449


How should Web Application Servers be usedwith PeopleTools 8.1x and PeopleTools 8.4?

1533


Explain the difference between temporary table and sql view in peoplesoft?

517


Explain how to taken care performance management in people tools?

507


What is record meta data?

532


What types of audits are supported by people soft?

527