Hey Raj, I think it generated by a tool. The original code had all kinds of hints, I asked her where comes from the hints, she said from the tool. Anyway, no suggestion? That's not like you. :)
joan > "Jamadagni, Rajendra" wrote: > > It need not be generatd by a tool, I have worked for a blood bank in > one of my previous projects. When it comes to matching a donor in th > records, you have to take a lot of precautions to see if you have a > duplicate donor etc. > > To me this seems to be logic to find duplicate customers ... our > algorithm was worse though . > > Raj > > -----Original Message----- > From: Mark Richard [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 4:51 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: slow query help > > I tend to agree with Stephane... > > It looks like that query was possibly generated by a tool. If not you > > should go talk to the person who wrote it. Find out what the business > > rules are and write it from scratch. In reality the query keeps > hitting > the same two tables, presumably looking for rows that have just been > loaded > which match existing rows in another table based on the names matching > in > some fashion (ie: perhaps incorrect firstname/middlename usage, etc). > > Name: ESPN_Disclaimer.txt > ESPN_Disclaimer.txt Type: Plain Text (text/plain) > Encoding: 7BIT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).