Database Tuning (MOSC)

MOSC Banner

How to avoid Full Table Scans from this query

edited Sep 5, 2010 4:48AM in Database Tuning (MOSC) 5 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center