Need help with tuning a query [message #457290] |
Sun, 23 May 2010 03:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ateeqrahman786
Messages: 52 Registered: December 2009 Location: Hyderabad,India
|
Member |
|
|
Hi,
I have a problem with some queries. I have attached a traced tkprof report. Please suggest some modifications.
Indexes on A_ULTIMA_ADVANCES
INDEX_NAME COLUMN_NAME POS_
A_ULTIMA_ADVANCES_IDX1 BUS_UNIT 1
A_ULTIMA_ADVANCES_IDX1 PT_CODE 2
A_ULTIMA_ADVANCES_NEW REG_NO 2
A_ULTIMA_ADVANCES_NEW BUS_UNIT 1
A_ULTIMA_ADVANCES_NEW TRANX_MODE 4
A_ULTIMA_ADVANCES_NEW SERVICE_TYPE_CODE 3
CASHINV BUS_UNIT 1
CASHINV INVOICE_NO 2
IDX3_A_ULTIMA_ADVANCES BUS_UNIT 1
IDX3_A_ULTIMA_ADVANCES CRE_DATE 2
IDX3_A_ULTIMA_ADVANCES TRANX_MODE 3
Indexes on A_PHARMACY_CASH_SALES
INDEX_NAME COLUMN_NAME POS
------------------------------ -------------------- ---------
CASHQTY SERVICE_TYPE_CODE 2
CASHQTY ITEM_CODE 3
CASHQTY BUS_UNIT 1
CASHQTY CRE_DATE 4
CASHSALES INVOICE_NO 2
CASHSALES BUS_UNIT 1
SYS_C0014755 INVOICE_NO 2
SYS_C0014755 SERVICE_TYPE_CODE 3
SYS_C0014755 SERVICE_CODE 4
SYS_C0014755 WHSE_CODE 5
SYS_C0014755 ITEM_CODE 6
SYS_C0014755 ITEM_REV 7
SYS_C0014755 CRE_NOTES 8
SYS_C0014755 BUS_UNIT 1
14 rows selected.
-
Attachment: newlog.txt
(Size: 13.27KB, Downloaded 1590 times)
|
|
|
|
|
|
|
|