Hello Friends ,
I think little bit confusion arise in previous tar of uninon operator .

Now let me simplyfy my requirement .

We have 110 different tables , all of these tables column names,datatype and field width are same.

Now when user do a query this query should point all tables
and out of which query retrieves only 25 rows .
No matter how many rows are retrieved from one table .

So query is going to point all tables but we need only 25 rows
in response .

I dont want to stik with union operator .

Just i want to know how will this possible . Database is of 3 terabytes , so also how can i get better performance .

Thanks
Jayesh