do you have an index on DRUG_BILL_ITEM for BILL_ID? otherwise IB/FB
will do a tablescan for every delete.



_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com