Is it a good practice to keep some extra columns in the tables giving a room of thought that there might be a reason to use those fields later down the road.
Just thinking of some performance issues.
Thanks,
shankar.
Printable View
Is it a good practice to keep some extra columns in the tables giving a room of thought that there might be a reason to use those fields later down the road.
Just thinking of some performance issues.
Thanks,
shankar.
Not really, esp. if you are using Oracle8 or a higher version, where you can add columns.
I wouldn't personally choose that option. Because I can at any time add and extra column to a table using alter table add. Suppose I don't get to use, I would just be wasting space.
But the choice is up to the design individual.
Sam
If you do not use a column, just drop it. In general, no extra columns are maintained in the schema.
Thanks a lot for ur help. I will incorporate the valuable suggestions u gave to me.