Re: Dealing with complex queries

On Mon, Feb 03, 2003 at 16:32:10 -0500,
  Francisco Reyes <lists@natserv.com> wrote:
> Any hints suggestions on dealing with complex queries.

>         substring(ppl.carried_as from 1 for 3)
>                 = substring(jc.last from 1 for 3) and

Joining on substrings is a good sign that your design needs rethinking.
This indicates that your data isn't normalized and it isn't going to
be particularly fast test (though I didn't check to see if it is a bottleneck
for the particular query you are doing).