Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • 1
    you're only using the hashcodes for a first check and then later verifying that the strings are actually equal is the correct usage of a hashcode, I guess. Commented Apr 28, 2010 at 16:51
  • @fortran - yes, it is. But the op isn't saying that: the implication from the question seems to be that they expect that if hashcodes are equal, then the set of strings is equal. Commented Apr 28, 2010 at 16:57
  • 1
    I don't read that at all. "so the joins are only processed by the database when the hash code matches" sounds exactly like the hashcode will be a first check. Commented Apr 28, 2010 at 19:44
  • 1
    @Geoff, you could certainly be right. If you are, I wasted 45 seconds typing. If you're wrong, this might save the OP days of unpleasantness. Commented Apr 28, 2010 at 19:56