<> 4
AND h.hostid in ({about 40 entries here})
AND h.host in ({about 40 entries here}))
AND fsys.src_time >= DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 6 HOUR)
ORDER BY fsys.src_time DESC
LIMIT 0,10;
Thanks,
Mark Ponthier
680Using where; Using temporary; Using
filesort
1 SIMPLE h ALL
PRIMARY,hosts_1,hosts_2 {null} {null}
{null} 96Using where
Thanks,
Mark Ponthier
From: Ananda Kumar [mailto:[EMAIL
src_time DESC
-> limit 0,10;
++-+---+---+-+--
---+-+--+---+---
---+
| id | select_type | table | type | possible_keys | key
| key_len | ref | rows | Extra
|
++
