On Wed, 9 May 2007 11:08:26 -0400 "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
> > I wonder if it would be beneficial to add an additional where clause which > can prefilter the data so you only need to perform the full calculation on a > subset of records. > > I haven't done the math, but let's supposed that point_x is 10 and that for > any result of your long calculation to be true, then x must be between 5 and > 15, then you can use the where clause > > WHERE > X BETWEEN 5 AND 15 > AND (point_x - x)^2 + (point_y -y)^2 < R^2; > Yes... it should help a little :) -- Biomechanical Artificial Sabotage Humanoid ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
