how to improve [message #363064] |
Fri, 05 December 2008 00:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
daredavil82
Messages: 1 Registered: December 2008 Location: ALASKA
|
Junior Member |
|
|
any one here have idea how to improve this query execution time?
select tEzai.c_tEzai_orgid as orgid,
tEzai.c_tEzai_tktype as tokenid,
tokentext as tokentype,
count(distinct c_tEzai_sno) as total,
count(distinct c_tEztkbind_sno) as consumed,
(count(distinct c_tEzai_sno) - count(distinct c_tEztkbind_sno)) as free
from tokentext LEFT JOIN tEzai ON tokenid = c_tEzai_tktype
LEFT JOIN tEztkbind ON tokenid = c_tEztkbind_tktype
where c_tEzai_orgid = 1 and c_tEztkbind_orgid = 1
group by tokentext order by tokenid;
|
|
|
|
|
Re: how to improve [message #363106 is a reply to message #363089] |
Fri, 05 December 2008 02:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Doh! Didn't see it.
Of course, this is an Oracle forum and we don't answer MySQL question.
Are you working on Oracle or MySQL?
Regards
Michel
|
|
|