How to avoid Full Table Scans from this query
We have a query which is causing full table scans on some of the larger tables we have in our database
All the columns of all tables on which we have joins are already been indexed but still full table scans are happening on all those tables
here is the query and the execution plan
SELECT
hdr.isf_seq_nbr, MIN(ct.container_nbr), hdr.importer_acct_cd, evtlg.event_date, hdr.status_cd,
ar.action_reason_descr, MIN(bl.master_scac_cd), MIN(bl.master_bill_nbr), MIN(bl.house_scac_cd),
MIN(bl.house_bill_nbr), hdr.isf_tx_nbr, hdr.booking_nbr, hdr.po_nbr, hdr.scac_cd, hdr.vessel_name,
here is the query and the execution plan
SELECT
hdr.isf_seq_nbr, MIN(ct.container_nbr), hdr.importer_acct_cd, evtlg.event_date, hdr.status_cd,
ar.action_reason_descr, MIN(bl.master_scac_cd), MIN(bl.master_bill_nbr), MIN(bl.house_scac_cd),
MIN(bl.house_bill_nbr), hdr.isf_tx_nbr, hdr.booking_nbr, hdr.po_nbr, hdr.scac_cd, hdr.vessel_name,
0