SQL Performance

[Contractor1@xxxxxxxxxxxxxxxxx]

We are using RUNSQLSTM to run a script that is chalked full of DELETE
statements and it is taking forever. We noticed that the delete statement
appears to be reading one record at a time and then deleting it. I say
appears because that is what I am assuming looking at the open files when
working with the job. The I/O count is double the relative record.

The files we are deleting have referential constraints. QQryDegree is set
to *Optimize (now). Hmmmm, that's all. If you need more information, just
ask.

So, any suggestions on how to speed this thing up? Write RPG program or
what?

Patrick Conner
www.ConnecTown.com
(828) 244-0822


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---