Optimize the query, help me please.

[Капралов Александр <alnkapa@xxxxxxxxx>]

Query is:

SELECT * FROM a UNION SELECT * FROM b  ORDER BY time DESC LIMIT 100

how can i get only last 100 row from a and b and then do union. Explain of select said that all recond selected from a and b.

thanks.