|
|
| Re: Performance tuning [message #313006 is a reply to message #311786] |
Thu, 10 April 2008 05:55   |
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 #313023 is a reply to message #313006] |
Thu, 10 April 2008 07:17 |
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?
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
