Helen,

Thanks for that. I guessed as much when I saw the plan rejecting the
index. I know it would be much smarter than I would be when it comes
to joins etc. I guess it is time to spend a bit more time studying
the use of joins.

Thanks again for the input.

Stewart

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> Stewart,
> This is NOT an IBO question but I'm going to comment on your query
because
> it has errors which affect the way IBO works...
>
> GOTO END
>
> At 07:29 PM 7/07/2003 +0000, you wrote:
> >I have 3 tables, and have created a join which seems to necessitate
> >an outer join, but for some reason the outer join seems to ignore
any
> >indices.