I've got this SQL that scans one table(t1) for records containing
(somewhere inside of a field) the fields of another table(t2) and
then joining the records of a third table(t3, parent to t1) but
only if the decimal column of t3 equals the SUM of the records
joined in t2...
It is a pretty advanced SQL and it takes a ***LONG TIME*** and it
probably can't execute within the speed of light anyway (due to the
advanced nature of the SQL) but what I would like to do is to
try to optimize it, but I am stuck.
I have ...