| Unused column in a table [message #90484] |
Thu, 27 November 2003 08:29  |
Pushparaj
Messages: 4
Registered: May 2002
|
Junior Member |
|
|
Does an unused column in a database table cause any overhead in terms of storage space.
By unused column I mean a column which is of a datatype number but will not contain any value ie null.
|
|
|
|
| Re: Unused column in a table [message #90486 is a reply to message #90484] |
Fri, 28 November 2003 16:41  |
Chadders
Messages: 18
Registered: November 2003
|
Junior Member |
|
|
|
Depends on it's position in the table and whether any subsequent columns contain data, but basically, if a column is NULL, it either "takes up" 1 or 0 bytes, i.e. 1 byte if the NULL column is "in the middle" of two non-NULL columns, otherwise, it's 0, i.e. at the "end" of the table.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
