Qurey taking much cost [message #381063] |
Thu, 15 January 2009 01:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1214 times)
|
|
|
|
Re: Qurey taking much cost [message #381282 is a reply to message #381164] |
Fri, 16 January 2009 02:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|