Re: Horrible SELECT !!!!

From: <place4oracle_at_my-deja.com>
Date: Mon, 28 Jun 1999 07:15:01 GMT
Message-ID: <7l77dj$9d2$1_at_nnrp1.deja.com>


Hello,

You need to do an explain plan of your select so we can see whats going on.

Place4oracle
http://altern.org/place4oracle/oracle_contents.html

In article <3776E49E.97148556_at_globalserve.net>,   Angelica Veron <Faro_at_globalserve.net> wrote:
> Hello Everyone,
>
> I am stuck with a somewhat complex SELECT statement, and wonder if
> anyone can come up with a streamlined version that would make it run
> quicker !.... this is the query, and it does work, only it takes
> forever to give a result !!.... is there a better way to re-write
this
> query with the same results ??.... any help would be greatly
> appreciated.
>
> CREATE TABLE FaroTemp AS
> (SELECT s.service_id, sfm.cust_id, c.cust_birthdate, s.service_p_type,
> (sfm.serv_loan_balance + sfm.serv_investment_balance) "Total Balance",
> rm.relmgr_id
> FROM customer c, service s, service_fact_monthly sfm,
> relationship_manager rm, talon
> WHERE rm.relmgr_num = talon.relmgr_num
> AND sfm.period_id = 1617
> AND c.cust_literature_flag <> 'N'
> AND s.pers_comm_cd IS NULL
> AND (to_char(sysdate, 'YYYY') - to_char(c.cust_birthdate, 'YYYY')
> BETWEEN 18 AND 99 OR c.cust_birthdate IS NULL)
> AND s.service_id = sfm.service_id
> AND c.cust_id = s.cust_id)
> /
>
> ...perhaps if no simpler query can be generated, can this query
> itself be broken down in steps and then joined to yield the same
results
> ??.... please help !
>
> Yours Sincerely,
> Angelica Veron
> Faro_at_globalserve.net
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 09:15:01 CEST

Original text of this message