Epstein, Ed wrote:

> I have 2 different tables with a double precision field in each one. Both
>
> are indexed. I am trying to perform a query of the values that are in both
>
> tables.
>
>
> I have tried many variations, but this is the most logical one to me:
>
>
>
> SELECT * FROM TABLEA INNER JOIN TABLEB ON TABLEA.FIELD1 = TABLEB.FIELD1
>
>
>
> The Plan that is generated for that is (TableA Natural,TableB (Index
>
> TableB_Field1_A))
>
>
>
> Wouldn't the best plan be to use both indexes?
>

There is a FK relation between TABLEA.FIELD1 and TABLEB.FIELD1?