Re: Normalization of attributes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 8 Nov 1999 12:56:15 -0000
Message-ID: <942065832.13287.1.nnrp-13.9e984b29@news.demon.co.uk>

Should 'abcxx' match 'abcyy' ?
Your example is much more precise
than your general statement.

Also do you have any high-precision
access method for either table, or is
this the only condition that will be applied.

Finally, how large is large, and what is the time-scale you are aiming at ?

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Peter Balon wrote in message <38220929.6FE2F27B_at_stud.uni-frankfurt.de>...
>Hello,
>
>I am looking for a way to improve search and comparison speed on large
>tables. The problem is that I have to compare two strings which might
>have different length. I need to check if the prefixes are equal so that
>
> T1.'abc' = T2.'abcd'
>and
> T1.'abcd' = T2.'abc'
>
>from both ends, with T1 and T2 as tables.
>Are there some known normalization techniques which I could apply?
>We are using Oracle 7.3 and will move to 8.x someday.
>
>Any comments would be greatly appreciated.
>
>thanks in advance
>
>Peter Balon
>
>
Received on Mon Nov 08 1999 - 06:56:15 CST