| Hal Berenson 2002-10-05, 9:07 pm |
| This does sound like some kind of suboptimal plan
problem. It could be statistics as Dinesh suggests.
You could speed up the cursor by adding the FAST_FORWARD
keyword to the cursor declaration. But I doubt that's
the issue.
How about posting the showplan_all output?
>-----Original Message-----
>Hi,
>This stored procedure used to be able to execute in 6.5
>within 10 minutes. Since I have loaded 2000 on my
>machine, it takes more than 300 minutes to finish the
>execution. The number of records in my database is more
>than 150,000. Once I reduced the records to 50,000, it
>runs fine, but in 6.5 I didn't have to reduce the
records,
>it ran fine. Do you know what's wrong?
>
|