Full Table Scan

From: Steven R Fuller <srfuller_at_doitnow.com>
Date: 1998/01/24
Message-ID: <6ajffq$680$1@usenet48.supernews.com>#1/1

HELP- I have created the following sql select statement, unfortualty when I runit I get multiple full table scan's, How can I eliminate this with out altering my select statement.

SELECT DISTINCT

    /*  INDEX (ptc)
        INDEX (ptosh)
        INDEX (ptm)
        INDEX (pcp)
        INDEX (cyc)
        INDEX (pyc)
        INDEX (dep)
        INDEX (phm)
        INDEX (bxc)
        INDEX (ptf) */
ptc.acctno,
ptc.adm_cust_no,
PTC.ADM_CUST_NO,
ptc.bin_no,
ptc.cap_cd,
ptc.carrier_no,
phm.chain_code,
ptc.claim_detail_gnrtd_id,
ptc.claim_type_cd,
pcp.closed_contact_cd_dt,
pcp.contact_cd,
pcp.contact_cd_status,
pcp.contact_date,
pcp.contact_reason_cd,
ptc.copay_amt_actual,
ptc.copay_amt_resp,
ptm.curr_card_id,
ptc.customer_no,
ptm.elig_gnrtd_id,
ptc.days_supply_no,

ptc.dispensing_fee_amt_submit,
ptc.contract_dispense_amt_resp,
ptosh.first_date_of_fill,

ptc.groupid,
ptc.group_no,
ptc.ingredient_cost_amt_actual,
ptc.ingredient_cost_amt_resp,
ptc.insno||ptc.inssub,
ptc.date_of_fill,
ptc.nabp_no,
ptc.ndc_no,
ptm.ophysno,

ptosh.order_status_cd,

ptc.pbm_bin_no,
ptc.pbm_card_no,
ptc.pbm_group_no,
ptc.pbm_pmt_amt,
ptc.adm_po_no,
ptc.polid,
ptc.processor_control_no,
ptc.qty_no,
ptc.rx_no,
ptc.sales_tax_amt_resp,
ptc.sales_tax_amt_actual,
ptc.sales_tax_dispense_amt_actual,
ptc.sales_tax_dispense_amt_resp,
PTC.sales_TAX_amt_ACTUAL,
ptc.total_amt_paid_actual,
ptc.total_amt_paid_resp,

ptosh.vials_used,
ptosh.vials_patient_year,

ptc.xps_entdate,
ptc.xps_trans_no,
bxc.class_of_trade_cd,
dep.med_educ_no,
dep.deano,
pyc.payer_cont_cd,
ptf.form_cd
FROM  pt_claim_detail ptc,
     pt_order_status_history ptosh,
        pt_master ptm,
        pt_contact pcp,
        carrier_group cyc,
        payer_contact pyc,
        dea_practitioner dep,
        pt_pharmacy phm,
        berlex_customer bxc,
        pt_form ptf

WHERE  ptc.compno = ptosh.compno
AND    ptc.acctno = ptosh.acctno

AND ptc.compno = ptm.compno
AND ptc.acctno = ptm.acctno

AND ptc.carrier_no = cyc.carrier_no
AND ptc.group_no = cyc.group_no

AND    ptc.compno = pcp.compno
AND    ptc.acctno = pcp.acctno
AND     ptc.insno = pyc.insno
AND     ptc.inssub = pyc.inssub
AND     ptc.compno = phm.compno
AND     ptc.acctno = phm.acctno
AND     ptc.customer_no = bxc.customer_no
AND     ptc.compno = ptf.compno
AND     ptc.acctno = ptf.acctno

Received on Sat Jan 24 1998 - 00:00:00 CST