Database Administrator (DBA) Question:
Download Questions PDF

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

Answer:

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

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
Why is a Where clause faster than a group filter or a format trigger?Where is the external query executed at the client or the server?