> I have serious performance problems with the following type of queries:
>
> Doesnt looks too bad to me, but i'm not that deep into sql query
> optimization. However, these type of query is used in a function to
> access a normalized, partitioned database, so better performance in this
> queries would speed up the whole database system big times.
> Any suggestions here would be great. I allready tested some things,
> using inner join, rearranging the order of the tables, but but only
> minor changes in the runtime, the version above seemed to get us the
> best performance.
Can you send the table definitions of the tables involved in the
query, including index information? Might be if we look hard enough we
can find something.
Peter