On Mon, Feb 03, 2003 at 16:32:10 -0500,
Francisco Reyes <lists(at)natserv(dot)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).