Database Administrator (DBA) Question:
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.
| Previous Question | Next 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? |