Re: Index or SQL?

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