At 11:33 PM 10/25/2002 +0200, Lele Gaifax wrote:

>While on subject, I'm experiencing an inexpected slow response from a
>SP that does several DELETE FROM xx WHERE PK>=:x in row

Approximately how many records would you expect to delete?
What other indexes do you have on those tables? How selective
are the other indexes?

>on a set of

Regards,

Ann
www.ibphoenix.com
We have answers.