Slow running Query Again

Hi all,
I have the following query which is running very slow as it takes few minut=
es to complete.

SELECT sum(nvl(as_ofcsh,0)),sum(nvl(as_offxd,0)),

sum(nvl(as_ofeqty,0)),sum(nvl(as_ofai,0))
FROM perfclient, assets_view, client
WHERE cl_decmkr=3D'64501013'
AND cl_clcode=3Das_clcode
AND as_date=3D '200312'
AND cl_clcode=3Dpc_clcode
AND pc_prfcomb in ('B', 'Y')
AND pc_grpdte !=3D '0000-00-00'
AND substr(pc_grpdte,1,4)||substr(pc_grpdte,6,2) <=3D '200312'

But if I run the following queries the response time is less than a second.

SELECT sum(nvl(as_ofcsh,0)),sum(nvl(as_offxd,0)),

sum(nvl(as_ofeqty,0)),sum(nvl(as_ofai,0))
FROM assets_view
WHERE as_clcode in '64501013'=20
and as_date=3D'200312'
select cl_clcode from=20
perfclient,client
WHERE cl_decmkr=3D'64501013'
AND cl_clcode=3Dpc_clcode
AND pc_prfcomb in ('B', 'Y')
AND pc_grpdte !=3D '0000-00-00'
AND substr(pc_grpdte,1,4)||substr(pc_grpdte,6,2) <=3D '200312'

CLIENT table has index on column "cl_clcode" and another index on "cl_decmk=
r".
PERFCLIENT table has index on column "pc_clcode"

So can you suggest some ways to improve this query.
Thanks in advance.=20

Dharminder Kumar

Dharminder Kumar
Senior Consultant
AllStream IT=20

<FONT SIZE =3D 1>**********************************************************=
******************
This e-mail and any attachments may contain confidential and privileged inf=
ormation. If you are not the intended recipient, please notify the sender i=
mmediately by return e-mail, delete this e-mail and destroy any copies. Any=
dissemination or use of this information by a person other than the intend=

ed recipient is unauthorized and may be illegal. Unless otherwise stated, o=
pinions expressed in this e-mail are those of the author and are not endors=
ed by the author's employer.</FONT>
Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.