joined:Mar 20, 2008
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.
Thanks in advance