Home » Other » Test » Test message
Test message [message #311786] Sun, 06 April 2008 17:45 Go to next message
balajimadhav
Messages: 3
Registered: April 2008
Junior Member
Test Message
Re: Performance tuning [message #313006 is a reply to message #311786] Thu, 10 April 2008 05:55 Go to previous messageGo to next message
anee459
Messages: 14
Registered: March 2008
Junior Member
select /*+ FIRST_ROWS(100) */ file_no,master_bl,container,
vesl_name,load_code,disch_code,eta_date
from imp_file_cont
where eta_date between to_date(sysdate-360) and
to_date(sysdate) AND STATUS = 'O' and substr(direction,2,1)='A'.

I m having this sql query is it is taking about 2 mins to execute.
Can anybody please help me out to reduce the execution time.
Re: Performance tuning [message #313010 is a reply to message #313006] Thu, 10 April 2008 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You failed the test.
This is not formatted.
Read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Don't forget always post your Oracle version (4 decimals).

Regards
Michel

P.S. If this is a real question and not a test, you have to post it in Performance forum.
Re: Performance tuning [message #313023 is a reply to message #313006] Thu, 10 April 2008 07:17 Go to previous messageGo to next message
anee459
Messages: 14
Registered: March 2008
Junior Member
anee459 wrote on Thu, 10 April 2008 05:55

select /*+ FIRST_ROWS(100)*/
file_no,master_bl,container,
vesl_name,load_code,disch_code,eta_date
from imp_file_cont
where eta_date between to_date(sysdate-360)
and to_date(sysdate) AND STATUS = 'O'
and substr(direction,2,1)='A'.


I m having this sql query is it is
taking about 2 mins to execute.

Can anybody please help me out to
reduce the execution time.

Is this ok Sir?


Re: Performance tuning [message #313025 is a reply to message #313023] Thu, 10 April 2008 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Almost.
Use SQL formatter to get a pretty looking and easy to read query.

Regards
Michel
Re: Performance tuning [message #313325 is a reply to message #313006] Fri, 11 April 2008 07:00 Go to previous messageGo to next message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
hello
Re: Performance tuning [message #313346 is a reply to message #313325] Fri, 11 April 2008 08:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hi!
Re: Test message [message #313405 is a reply to message #311786] Fri, 11 April 2008 13:40 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Laughing
Previous Topic: Show Sum
Next Topic: testing
Goto Forum:
  


Current Time: Thu Mar 28 09:27:29 CDT 2024