Advanced Setting - RSVP.QUERY.OPTIMIZEQRD = TRUE

Technote (FAQ)


Question

What are QRD´s and how does optimizing them result in better querying on large reports?

Answer

Query Result Definitions (QRDs) are used in a report to request the data as it should be laid out. This means for every element on the report page (list, crosstab, chart) the layout components creates a QRD and hand this over to the query engine. The QRD describes in which format the data is expected from the query engine so to fit to the user requested layout. So it could be that a lot of QRDs are executed and takes resources.

The optimization will collect all QRDs and analyse if some parts of QRDs can be reused or equal to reduce work for the query engine and the database. Especially on large reports it is a good opportunity to reuse and pool QRDs.

Also, there is no benefit on small and simple reports unless the different elements uses the same query.

Its not database specific, It´s used for an internal optimization before sending the queries to the database.


Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Business Intelligence Install and Config AIX, HP-UX, HP Itanium, Linux, Solaris, Windows 8.3, 8.4

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Install and Config

Software version:

8.3, 8.4, 8.4.1, 10.1, 10.1.1

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1388934

Modified date:

2013-10-18

Translate my page

Machine Translation

Content navigation