Re: Horrible SELECT !!!!

Try putting this condition "sfm.period_id = 1617" to the last. The purpose is to have a small driving table.

Angelica Veron wrote in message <3776E49E.97148556_at_globalserve.net>...
>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
>
Received on Mon Jun 28 1999 - 04:19:37 CEST