Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

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

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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?