Tag Info

New answers tagged

3

First I'm assuming that both ID and Type are INT columns. Second that this is going to be a somewhat active table with a fair number of inserts (and possibly deletes). And last but not least that you aren't going to be pulling a "range" of IDs. For example you don't need to look at ID 10000-15000. If so I would create a third column that is an INT ...


0

I'm no expert but I see couple of potential pros and cons. So if you use table1, and you list each row for after every data change, what will happen? Well if you have lot of small updates like only changing one field at a time, then you will have a lot of redundant data from the unchanged fields. If you only list the fields that have changed and leave the ...



Top 50 recent answers are included