OraFAQ Forum: Performance Tuning » Need help with tuning a query

Home » RDBMS Server » Performance Tuning » Need help with tuning a query (8.0.6, win 2000 server)

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

Need help with tuning a query [message #457290]

Sun, 23 May 2010 03:03

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 1488 times)

Report message to a moderator

Re: Need help with tuning a query [message #457291 is a reply to message #457290]

Sun, 23 May 2010 03:12

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As you don't:
- make the effort to format your post
- take time to answer our questions to help you
- have the courtesy to feedback when someone help
why should we bother to now answer you?

Regards
Michel

Report message to a moderator

Re: Need help with tuning a query [message #457292 is a reply to message #457291]

Sun, 23 May 2010 03:18

ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India

Member

1) How can i re-edit my question.

2) As i am a newbie, i sometimes need time to understand what u guyz suggest.

3) As i forgot my password, i couldn't log in since long time.

Report message to a moderator

Re: Need help with tuning a query [message #457294 is a reply to message #457292]

Sun, 23 May 2010 03:59

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

1/ you cannot

2/ Good.dont use IM speak ("U")
3/ No problem now right?

sriram Smile

Report message to a moderator

Re: Need help with tuning a query [message #457296 is a reply to message #457292]

Sun, 23 May 2010 04:29

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

First review all the topics when you didn't answer and/or feedback and do it NOW.
About IM speak, we already told to NOT use it, so do it NOW.

Regards
Michel

Report message to a moderator

Re: Need help with tuning a query [message #457905 is a reply to message #457296]

Wed, 26 May 2010 06:07

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Can you create aggregate tables?

Report message to a moderator

Previous Topic:	V$SESSION_LONGOPS - Looking for more than last 16 ops
Next Topic:	P&T Guide Question [Restructuring SQL Statements]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 19:38:24 CDT 2024