What Alter Table ADD & DROP does to existing table with millions of records?
Very recently one of my client argued on the effect ALTER TABLE ADD or ALTER TABLE DROP column has on an existing table having millions of records. AFAIK, the add column and drop column do not have a significant impact as the changes made are matadata changes. Still, to prove the point , here is […]