Optimizing this query [message #324659] |
Tue, 03 June 2008 10:11  |
balaji23_d
Messages: 123 Registered: February 2007
|
Senior Member |
|
|
Hi all,
When i useing this stmt in my query, It will take more time
so it will show bad performance
order by NVL(worg1.ucnworg_oper_distr_code,'00A00')
So we can modify this stamt, instead of using the NVl fn
|
|
|
|
Re: Optimizing this query [message #324665 is a reply to message #324663] |
Tue, 03 June 2008 10:19   |
balaji23_d
Messages: 123 Registered: February 2007
|
Senior Member |
|
|
No Michel,
when i tuning my query, If i used the NVL functin to be placed in order by clause...when i execute It will take more time to get the result.
So please suggest me is any other way will do this work
|
|
|
|
Re: Optimizing this query [message #324706 is a reply to message #324659] |
Tue, 03 June 2008 13:54  |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
An order by is executed after all the rows have been selected and will not have a major effect on the actual query. Of course, if no ordering is done, it would be faster.
|
|
|