DEVFYI - Developer Resource - FYI

Why is it preferable to create a fewer no. of queries in the data model?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

265. Why is it preferable to create a fewer no. of queries in the data model?

Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

(Continued on next question...)

Other Interview Questions