Re: Indexing one byte flags - what implementattion is better

2007-12-28 Thread Artem Kuchin
Garris, Nicole wrote: Is id a sequential number? And is it referenced by other tables? If so, and if over time new products become "old" products, then CASE 2 is more complex, because when moving a product (i.e., a row) from the new product table to the old product table, the value of id needs to

RE: Indexing one byte flags - what implementattion is better

2007-12-27 Thread Garris, Nicole
Is id a sequential number? And is it referenced by other tables? If so, and if over time new products become "old" products, then CASE 2 is more complex, because when moving a product (i.e., a row) from the new product table to the old product table, the value of id needs to stay the same. So for C