Re: SQL statement help

From: Brent Tucker <btucker_at_servman.com>
Date: Fri, 24 Sep 1999 15:09:27 -0600
Message-ID: <runq4td3i554@corp.supernews.com>

Can you provide an explain plan for the statement? That would help a lot.

Brent Tucker
www.servman.com

Ed Lufker wrote in message <7sgm49$5mk$1_at_sloth.swcp.com>...
>Hi All:
>
>Could someone please tell me how I could write the following statement in
>a more effient manner. The statment is running too too long. All columns
>are indexed.
>
>select couponorder.cporid from HBFADMIN.COUPONORDER
> , HBFADMIN.COUPONORDERDETAIL
> , HBFADMIN.SPONSOR
> , HBFADMIN.SITE
> , HBFADMIN.STATE
> , HBFADMIN.COUNTY
> , HBFADMIN.CAMPAIGN
> where couponorder.cpordate BETWEEN '16-SEP-99' AND '17-SEP-99'
> AND couponorder.cporstateid = state.id
> AND couponorder.cporsiteid = site.siteid
> AND state.state_id = county.state_id
> AND couponorder.cporcountyid = county.county_id
> AND couponorderdetail.cpodsponid = sponsor.sponid
> AND couponorderdetail.cpodcampid = campaign.campid
> ORDER BY cporid;
>
>Thanks in advance for any help here.
>Eddie Lufker
Received on Fri Sep 24 1999 - 16:09:27 CDT