"Terry Johnson" <terry@...> wrote:

>
> Select * from TRANS where STORE=x and TRAN_DATE>start_date
>
> Select * from TRANS join ITEMS on ITEMS.TRAN_ID=TRANS.ID where
> TRANS.STORE=x and TRANS.TRAN_DATE>start_date

It would be much easier to help if you'd show us execution plans for both
queries.


Dmitry