| Need Help for Mysql-Query optimization [message #3702] |
Fri, 07 November 2008 07:26  |
 yashvant
Messages: 1
Registered: November 2008 |
Junior Member |
|
|
I have run this query make a more time please any body optimize this query as blew
$sql="SELECT f.feeder_code, f.subdivision_code FROM `feeder` f, sentout s
where ( f.start_date <= '2008-07-01' and f.end_date >= '2008-07-01' and
(s.month = 7 and s.year = 8 )) and f.feeder_code = s.feeder_code
UNION
SELECT feeder_code, subdivision_code FROM ht WHERE ht.month = 7 and
ht.year = 8 and concat( feeder_code, subdivision_code ) NOT IN
(SELECT concat( f.feeder_code, f.subdivision_code )
FROM `feeder` f, sentout s where (f.start_date <= '2008-07-01' and f.end_date >='2008-07-01' and (s.month = 7 and s.year = 8)) and f.feeder_code = s.feeder_code)
UNION
SELECT feeder_code, subdivision_code FROM lt WHERE lt.month = 7
and lt.year = 8 and concat( feeder_code, subdivision_code ) NOT IN
( SELECT concat( f.feeder_code, f.subdivision_code ) FROM feeder f, sentout s
where (f.start_date<= '2008-07-01' and f.end_date >= '2008-07-01' and
(s.month = 7 and s.year = 8)) and f.feeder_code = s.feeder_code
) AND concat( feeder_code, subdivision_code ) NOT IN ( SELECT concat( feeder_Code, subdivision_code )
FROM ht WHERE ht.month = 7 and ht.year = 8)
ORDER BY feeder_code, subdivision_code";
solved this problem because this take a more time
[Updated on: Fri, 07 November 2008 07:31]
|
|
|
|
Members
Search
Help
Register
Login
Home
