Subject | separate table or separate database |
---|---|
Author | Sean |
Post date | 2007-07-27T16:17:24Z |
Hi,
To improve query performance, I am thinking to split a huge table into
several small tables. Is there any performance difference between
splitting into several *tables* in the same database and splitting the
table into a small table in several *databases* ?
Best,
Sean
To improve query performance, I am thinking to split a huge table into
several small tables. Is there any performance difference between
splitting into several *tables* in the same database and splitting the
table into a small table in several *databases* ?
Best,
Sean