Re: Sql - Best way?

From: Simon Griffiths <s.griffiths_at_virgin.net>
Date: Thu, 25 Jun 1998 22:25:09 +0100
Message-ID: <3592C035.EB5E29EC@virgin.net>

Lisa Lewis wrote:

> Can anyone give me any insight as to what might be the best way to do the
> following: On a table with 500,000 rows, compare every row to every other
> row in the table (500,000X500,000 comparisons) ...

> Lisa

Whichever way you try to do that many comparisons will take too long. Try partitioning the data in some way to reduce the comparisions.

Perhaps group rows into ranges of values, and then compare within the ranges.

Simon. Received on Thu Jun 25 1998 - 16:25:09 CDT