[GENERAL] Optimize the query, help me please.

[Капралов Александр]

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.