OraFAQ Forum: Performance Tuning » Qurey taking much cost

Home » RDBMS Server » Performance Tuning » Qurey taking much cost (10GR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Qurey taking much cost [message #381063]

Thu, 15 January 2009 01:36

sanjayocp
Messages: 1
Registered: January 2009

Junior Member

THis qurey is taking high cost. pls help me....Explain plan is as attachment

SELECT a.issnc_dte,
a.issnc_dsc,
a.amt,
a.check_num,
a.undelivered_check_xref_num,
b.ssn_num,
c.pgm_cd_code_k,
a.client_id_issuee_k,
a.ID,
c.grantee_first_nam_d,
c.grantee_last_nam_d
FROM au_ben a, au_ben_items b, au c
WHERE a.client_id_issuee_k = 1927488
AND b.au_ben_id_k = a.ID
AND a.au_id_k = c.ID
ORDER BY c.pgm_cd_code_k DESC, a.issnc_dte DESC

Attachment: PLAN.txt
(Size: 1.11KB, Downloaded 1136 times)

Report message to a moderator

Re: Qurey taking much cost [message #381164 is a reply to message #381063]

Thu, 15 January 2009 08:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You have table & provided us no DDL for it.
You have data & provided us no DML for test data.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Report message to a moderator

Re: Qurey taking much cost [message #381282 is a reply to message #381164]

Fri, 16 January 2009 02:29

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

- How many rows dows it return
- How many rows in each of the tables
- How many rows have a.client_id_issuee_k = 1927488
- client_id_issuee_k is the SECOND column of index BEACON.AU_BEN_NK1. What is the first column, and HOW MANY different vales of that column exist.

Ross Leishman

Report message to a moderator

Previous Topic:	Database slow after attaching new storage
Next Topic:	query taking lot of time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 16:21:24 CDT 2024