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
I got news, I can see now what's iniside the cursor, it's a "Create proc" .... why cognos is genarating procs ???
thks