RE: SQL Delete

 If you set up a logical file/index with field Z1PRFL as a key, the SQL 
Optimizer should use that index (and not scan through the records) when 
performing the delete. Joe Kempenich--- On Mon 03/20, Wes < 
destaw@xxxxxxxxxxxxxxxxxxx > wrote:From: Wes [mailto: 
destaw@xxxxxxxxxxxxxxxxxxx]To: midrange-l@xxxxxxxxxxxxxxxx: Mon, 20 Mar 2006 
14:33:43 -0700Subject: SQL DeleteI'm running this SQL in interactive SQL 
session...===> delete FROM fonew WHERE Z1PRFL in ('Y', '*' )F3=Exit 
F4=Prompt F6=Insert line F9=Retrieve F10=CopF12=Cancel F13=Services F24=More 
keys---> Query running. 0 records selected, 29270544 processed.The funny 
thing is the SQL is saying it's processed 29 million records whene only has 
about 3k records are in the table and the 30mil are deleted (Iknow I should 
re-org this file but time doesn't allow it since the table isbeing used by 
trigger program)Text:Total number of members . . . . . . . . . : 1Total number 
of members not available . . : 0Total records 
. . . . . . . . . . . . . . : 1222Total deleted records . . . . . . . . . . : 
30853279Total of member sizes . . . . . . . . . . : 25004580864Is there any 
know reason why SQL scans the full table including deletedrecords?Wes-- This is 
the Midrange Systems Technical Discussion (MIDRANGE-L) mailing listTo post a 
message email: MIDRANGE-L@xxxxxxxxxxxxxx subscribe, unsubscribe, or change list 
options,visit: http://lists.midrange.com/mailman/listinfo/midrange-lor email: 
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx posting, please take a moment to review 
the archivesat http://archive.midrange.com/midrange-l.

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com