-
extra fields while design of tables...
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
Thanx
Sam
Life is a journey, not a destination!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|