Home » RDBMS Server » Performance Tuning » Qurey taking much cost (10GR2)
Qurey taking much cost [message #381063] Thu, 15 January 2009 01:36 Go to next message
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 141 times)
Re: Qurey taking much cost [message #381164 is a reply to message #381063] Thu, 15 January 2009 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.



Re: Qurey taking much cost [message #381282 is a reply to message #381164] Fri, 16 January 2009 02:29 Go to previous message
rleishman
Messages: 3724
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
Previous Topic: Database slow after attaching new storage
Next Topic: query taking lot of time
Goto Forum:
  


Current Time: Sun Dec 11 02:06:47 CST 2016

Total time taken to generate the page: 0.05105 seconds