A
Andriy Mishin
Guest
[quote user="ChUIMonster"] I don't remember what CDC does about tables without unique keys. IMHO such tables ought not to exist 
If they do exist the responsible designer always seems to have fled the scene of the crime... Apparently you have a table without a unique key? Is it a large table? Or something small and readily dealt with as an exception? [/quote] I agree with you. But such databases are passed to me "by inheritance" and as a rule it's too late to change something. Yes, there are such tables in the database. Five of them have a small size from 2.5 GB to 3.2 GB. The size of one table is 34 GB. But this is not a problem, I think I will deal with them through a binary dump. But there is one table with a size of almost 900 GB...
Continue reading...
If they do exist the responsible designer always seems to have fled the scene of the crime... Apparently you have a table without a unique key? Is it a large table? Or something small and readily dealt with as an exception? [/quote] I agree with you. But such databases are passed to me "by inheritance" and as a rule it's too late to change something. Yes, there are such tables in the database. Five of them have a small size from 2.5 GB to 3.2 GB. The size of one table is 34 GB. But this is not a problem, I think I will deal with them through a binary dump. But there is one table with a size of almost 900 GB...Continue reading...