DataSource Controls :: Make Union Query Better?

in my application i should make an union query thay union 15 tables

and this query begin with 150000 rows and will grow .

i need get just 10 rows from this query

i want make this query as best as possible

2 qustion

-----------------------------------------------------------1------------------------------------------
********View1*******
select id, lang, active from table1
union
select id,lang,active from table2
...--same way to all other 15 tables
*******SP***********

select top 10 from View1 where active=1 and lang='he' order by id desc

or
********View1*******
select id, lang, active from table1 where active=1 and lang='he'
union
select id,lang,active from table2 where active=1 and lang='he'
...--same way to all other 15 tables
*******SP***********

select top 10 from View1 order by id desc

---------------------------------------------2---------------------------------------

becauseof that this query is very complicate i want to know if i need take just 10 from each table

------------------------------------------------3--------------------------------------

if there is an idea how make this query better, i will glad to know.