Cognos Query tool & Native query tool

[elisha]

cognos query tool & native query tool which one is faster & why it is faster ?. Is it depending on query or not ?. Is it depending on database or not?.

[sir_jeroen]

In relation to what do we have to see this (what's the purpose of this question):

1) ReportNet vs. Native Querytool
2) ReportNet query subject running in Cognos sql vs Native sql vs Pass-Through sql

Please clarify

[Merri]

And exactly what do you mean by a "native query tool"? Something provided by the database vendor? Or a tool based on a native connection to the database?

[elisha]

Thank you addict

purpose :
Performance wise which one is faster.  

My exact question is in your second point.  

More clarification
I'm running a query in Impromptu or Framework Manager. Taking the same query including joins & filters running in SQL * PLUS. If i compare the execution time for both  which one is first retrieve the data & why ? . 

[sir_jeroen]

SQL * Plus will retrieve ALL rows; ReportNet will retrieve only a Portion (in most circumstances)

In general you can say that queries in Native SQL are faster than Queries eg in Cognos Query because these have to be translated to Part Native and Part Cognos (those functions which are unfamiliair to SQL eg. _last_day_of_month are handled by Cognos).  But native queries are all executed on the server and therefore will produce a higher Serverload therefore your DBA-er would like to see less Native and more cognos (Handled by Cognos).

So there's no "optimal" method.. It's a mix...

But... please correct me if I'm wrong....

[elisha]

Thank you addict

i tried to understand what you are telling but i failed to get Fully. Please can you give more clarification ?.