I have a few questions regarding "databases" or "database files." I see how one can divide a particularly large schema structure over several files and then perform attach and detach database commands on them to get the whole thing again.
1) Is this a valid use of this construct? 2) Is there any difference, in terms of performance, between a single database or two or more databases attached to the default one? 3) When doing complex joins against two tables, is there a difference between when the tables are in one database or in two separate databases? I mean syntactically, I would use the database.table name syntax but other than that, is there a difference in terms of reliability or efficiency? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
