Cognos SQL:
Generic representation of a Query.
More verbose than native sql
Formatted for readability and comprehension and generated by CQE
Native SQL:
Designed to use the database optimizers.
Leverages features of databases wherever possible.
We cant use Native SQL in a Query subject that references more than one data source query subjects
Pass-through SQL:
Use When a database vendor does not extend support for a particular construct in a sub-query.
Cognos 8 will pass anything you type directly to the database.
With Pass-through SQL what ever you type is passed to the Data base processing with out the intervention of the Cognos 8 Query Engine
Generic representation of a Query.
More verbose than native sql
Formatted for readability and comprehension and generated by CQE
Native SQL:
Designed to use the database optimizers.
Leverages features of databases wherever possible.
We cant use Native SQL in a Query subject that references more than one data source query subjects
Pass-through SQL:
Use When a database vendor does not extend support for a particular construct in a sub-query.
Cognos 8 will pass anything you type directly to the database.
With Pass-through SQL what ever you type is passed to the Data base processing with out the intervention of the Cognos 8 Query Engine
No comments:
Post a Comment