Re: Index or SQL?

In article 2_at_mhadg.production.compuserve.com, Steve Edelstein <74160.645_at_CompuServe.COM> () writes:
>Are yoe *SURE* that the data in the supposedly equal fields are
>the same? No spaces or things like that? One place where these
>joins often fail is in date fields. This has nothing to do with
>indexes per se. The problem is with the TIME portion of the date.
>If the two dates were inserted at different times the time added
>onto them is different and therefore cannot be equal, even tho
>the date protion is the same (as in DOB). the check this, change
>the join specification to :
>
>TRUNC(a.dob) = TRUNC(b.dob)
>
>If the time is different, this will perform the equality check
>without it.
>
>Hope this helps.
>
>--
>Steve Edelstein VOICE: 212-956-3670
>Relational Business Systems CompuServe: 74160,645
>124 West 60th Street Suite 47C
>New York, NY 10023

I didn't catch the beginning of this thread, but another fun thing is that Forms 4 gets stuck with CHAR fields in an Oracle 7 DB. One of the few places I've found where the comparisons differ!

BTW Hi Steve!

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216