I currently have 601 tables that I search through. It's taking way too long. Is there anything I can do to make the searching faster? All the tables have the same column names and types. Will it be faster to combine some of the tables into one?
any help?
