Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle For Fun

Re: Oracle For Fun

From: Jeff <jeff_at_work.com>
Date: Tue, 03 Feb 2004 14:37:22 GMT
Message-ID: <bvobn2$plc$1@cronkite.cc.uga.edu>


In article <1075736677.640811_at_yasure>, Daniel Morgan <damorgan_at_x.washington.edu> wrote:
>Jeff wrote:
>
>> One other thing... tranditional still seems to be setup for SSN's, not phone
>> numbers... it could be that one reason it's so much faster is because it's
>> failing the test (incorrectly) earlier.
>
>Good catch. The new number is 69 in 9i and I'll recheck the 10g
>number later today.

To be fair, it should be noted that the test results are "worst case" for the traditional routine (and possibly owa match and regexp?) because there is no invalid data being tested--though I think this would be rather difficult to do without a "real world" dataset. Received on Tue Feb 03 2004 - 08:37:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US