select query going on full table scan

Hi all,

I m executing one select query which is going on full table scan for 2 tables out of five tables.

below is the query:

Select a.action_type OrderActionType,

1. a.status OrderActionStatus,
2. a.order_unit_id OrderActionId,
3. b.vodafone_order_ref,
4. a.ap_id MainComponentID,
5. a.parent_relation OrderActionLevelType,
6. c.action_type ComponentLevelActionType,
7. c.offer_def_id Component_ID,
8. d.caption ComponentName

From vfpoms.tborder_action a, vfpoms.tborder_header b, vfpoms.tbap_item c, vfpoms.tbcatalog_item d,tbdynamic_bill_prop e

where a.order_id = b.order_id

and a.order_unit_id = c.order_action_id