now i have a question, because in our project
some tables have too records ,so the speed of the run application is
very slow ,
we plan to use partition table. but what can we do ?
the restriction condition as followers
the original data in the table ,
means how could i move the data .to other partition tables,
and at the same time the foreign key also must be taken
account.
the table have 2 foreign key , namely reference to other tables
and these tables may be change into partition table also.
so how can we use partition table ?
can anyone help me?
our operation system is windows ,and the language is java .
henry