Horrible SELECT !!!!

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 Sun Jun 27 1999 - 21:57:34 CDT