At 13:59 14.10.2002 +0000, you wrote:

>Yes, speed is the essential problem. The query produces the correct
>results, so this is not an issue.
>
>In case you really want to see the query :-)

...skipped long query for reading at home tonight

>XAK* indeces are unique. What do you mean by "size" of assay table?
>Number of rows or columns?

Number of rows, and while your at it, number of rows in the PROFILE table
as well. (My question is starting to become "why use NATURAL for the ASSAY
table?")

Set