Msg#: 4305679 posted 12:00 am on Apr 29, 2011 (gmt 0)
Hi, I have a database which has about 200 tables in it, which need to be searched at once. Is there a best practice to search all these tables at once, other than writing an enormous UNION type query in MySQL?
PS: This is not a poor database design, just a large part of a very large whole, which cannot be separated.
Seems like you are going to need to setup some sort of aggregate read-only view/table that combines all of these tables into a data warehouse. Not sure if MySQL would be the best dbms to use for this much data, though. or if they have tools that would make this simpler.
But once you have the DW set up, you would just query against that.