Sybase performance issue

[mhamedbj]

Hi every one,


I got a simple list report, with 5 column and 3 join, when I copy past the generated sql in Sybase central, it took 2 sec to answer, but when I run the report it take 3 min !!!

I tried to see the running sql in session explorer but it's a cursor.

How can I tell Cognos not to use cursor, and why it take that long ?

thanks

[mhamedbj]

I got news, I can see now what's iniside the cursor, it's a "Create proc" .... why cognos is genarating procs ???

thks