Print Page - User defined Sql vs stored procedures

Title: User defined Sql vs stored procedures
Post by: vsudaya on 09 Sep 2005 10:29:45 PM

Hi,

Anybody can tell me which one will give best performance(User defined sql or stored procedures) when yu are using report studio?

thanks regards
vsudaya

Title: Re: User defined Sql vs stored procedures
Post by: BIsrik on 13 Sep 2005 12:37:18 AM

Ofcourse SP is more efficient in performance than the user defined Sql. But SP had to be executed atleast once before testing the performance with the user defined Sql.

But the report design flexibility is more with the user defined sql than the SP.

Srik

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: vsudaya on 09 Sep 2005 10:29:45 PM