Could you please help me out, i have table with 9 columns and about a million rows,
i need to add primary key, so what things do i need to consider here,
what if my table has no unique column / columns(composite), wat can do in this situation
adding a id field (just 1 to .... so on) and then making this pk, does makes any sense?
could you please help me out here
Thanks a ton in advance