Re: SQL, Logical Files, Unions & Indexes.

The one piece of information that you did not give us was how long does
it take to run the query over a single library and how much data does it
return? 

If this is very quick, the union would do the trick pretty quick except
you end up writing 50 SQL Statements. 

I am not sure whether putting an index over the fifty libraries would
help much. I wonder if SQL would even be able to use it. I would think
it would simply drop through to one physical. 

One solution to this would be in code. Just loop around writing dynamic
SQL statements to retrieve each library and write to a Global Temporary
Table. Then one SQL to present the results. 

This would prevent you from having to write 50 SQL Statements for each
library.