View previous topic :: View next topic
|
Author |
Message |
Ramki Balakrishnan
New User
Joined: 22 Aug 2011 Posts: 5 Location: India
|
|
|
|
Hi All,
I am tuning a join query.
I am comparing the efficiency of old query and new query(after performance tuning). While searching regarding this, I came to know about TOTAL_COST from DSN_STATEMNT_TABLE.
Is there anyway to convert TOTAL_COST in terms of Dollars. Because I need to show the difference in Dollars.
Thanks,
Ramki B |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
|
|
Ramki,
difficult to get into the question, could you please provide with in/out sample data. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
the TOTAL COST of a query is usually expressed in darseks
You will need to find a currency converter with the proper up to date exchange rates |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
There is no generic "convert to $" that i am aware of. Largely due to the fact the so many organizations have different "costng" rules (which IMHO are mostly worthless). |
|
Back to top |
|
|
|