Re: SQL Delete Performance - Why so Horrible?

Absolutely. An index would help tremendously.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             William                                                       
             Washington III                                                
             <w.washington3@sb                                          To 
             cglobal.net>              midrange-l@xxxxxxxxxxxx             
             Sent by:                                                   cc 
             midrange-l-bounce                                             
             s@xxxxxxxxxxxx                                        Subject 
                                       SQL Delete Performance - Why so     
                                       Horrible?                           
             04/14/2005 04:34                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Hi All,

Why is the SQL DELETE performace so terrible?

I have a file with 1,500,000 records.  When I do:

DELETE FROM filename WHERE company = pCompany

in a stored procedure running in batch, it takes nearly 30 minutes!  Of
course,
an SQL DROP or a CL "CLRPFM" works within seconds, but I really must check
the
company before deleting.

Would indexing by company help?

Thoughts?  Ideas?  Thanks.

William

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.