This SQL dont use indexes

Hi

I have a problem here.

The following SQL woun't use indexes whatever I do.

select

   a.trx_line_id
, a.description
, sum(a.amount)
, b.date

from

   mother_table b
, child_table a

where

   b.trx_id = a.trx_id;

The trx_id is primary_key in mother_table and the first column in a 3 column index for the child table.

The child_table contains abount 4 mil rows, and the mother_table abount 500 000.

When I do an explain_plan bount the mother- and the child_table are accesed by full table scan.

What do I do wrong? Received on Mon Nov 11 2002 - 22:41:42 CET